Database locked

[danitrin via AccessMonster.com]

I split my database and each user has their own copy of the front end on
their desktop. When you try to open a form in front end the user is getting
a message saying file locked. I made sure that the open mode was set to
shared. What am I missing?

 

[John W. Vinson]

I split my database and each user has their own copy of the front end on
their desktop. When you try to open a form in front end the user is getting
a message saying file locked. I made sure that the open mode was set to
shared. What am I missing?

You need to check the sharing in three places:

1. Each user should have their own individual copy of the frontend. This can
be opened either shared or exclusive.
2. The backend must be set to Shared.
3. The user must have full read, write, create and delete privileges on the
folder containing the backend.

 

[danitrin via AccessMonster.com]

All three are already in place and have been checked, any other thoughts?

 

[John W. Vinson]

All three are already in place and have been checked, any other thoughts?

What version of Access? What service pack? Are the frontends on the user's
desktop or on the network? Where's the backend, and how is it linked (mapped
drive name, or - better - \\server\share\)?

 

[danitrin via AccessMonster.com]

Access 2003, SP1 (I think - I will have to double check tomorrow). The front
ends are on the users desktop and the back end is on the a shared drive. The
two are linked by drive name rather than server name.

 

[John W. Vinson]

Access 2003, SP1 (I think - I will have to double check tomorrow). The front
ends are on the users desktop and the back end is on the a shared drive. The
two are linked by drive name rather than server name.

Try opening the master .mdb copy of the frontend (you *are* distributing
..mde's, I hope...); DELETE all the table links; use File... Get External
Data... Link to relink to the backend; make a .mde and distribute it to see if
it's working better.

Drive names can work if all users have exactly the same drive mapping, but it
may be preferable to navigate to the backend via Network Neighborhood rather
than via My Computer, which will provide the \\server syntax. I believe that
it's faster, and it's certainly less vulnerable to user meddling.