Re: 2nd User Can't Open db on LAN

All users need read/write/create Windows permissions on the folder where the backend is located. This is so the associated ldb file can be created.


--
Joan Wild
Microsoft Access MVP
"croy" <croy@xxxxxxxxxxx> wrote in message news:a43ao3lac4noeqef1drucotfambhsbtcpb@xxxxxxxxxx
We moved the back-end of an Access 2002 mdb to a LAN server.

When person1 opens the db, person2 gets a message that
"Access can't open the file 'admin'...".

If person1 closes the db, person2 can open it with no
problems.

If person2 opens the db first, person1 can open it without
problems!

In Tools|Options|Advanced the default open mode is shared,
and "Open the database using record-level locking" is
checked (both computers).

Does anybody here have any ideas?

--
Thanks,
croy
.

Relevant Pages

  • 2nd User Cant Open db on LAN
    ... We moved the back-end of an Access 2002 mdb to a LAN server. ... If person1 closes the db, person2 can open it with no ... If person2 opens the db first, ...
    (microsoft.public.access.security)
  • RE: file sharing
    ... This is done through Explorer. ... Say person 1 opens the file and then person 2 opens the file, ... person1 closes user 2 gets a notice that they can enter read write ... from showing? ...
    (microsoft.public.excel.programming)
  • Re: Running an Access macro from a VB.NETprogram
    ... create a ldb file. ... If your Access mdb is ... My program opens Access to try to do this.. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: close / rename linked .mdb file
    ... except when Access "opens" it to deal with the ... code in the startup procedure which opens a database or recordset ... Opening the .ldb file using notepad will show you both who's currently ... Determining the workstation which caused the Microsoft Access MDB ...
    (microsoft.public.access.modulesdaovba)
  • RE: Check for Exclusive
    ... revise and implement it into our live database. ... "Paolo" wrote: ... Look at the size of the ldb file. ... If a user opens the database when it was not previously open, ...
    (microsoft.public.access.modulesdaovba)
Loading