Multi-User Access Project

[Greg Gavin]

I am trying to deploy an Access (2002) data project using SQL server 2000 as the back-end from a network location. When the second user attempts to open the project he is confronted with a message that the "MS Access Project will be opened read-only due to the file being locked for edit." I want to be able to have multiple users open the same project (front-end) at the same time.

This is obviously due to the first user having the project open, but how do I set the project to be opened without locking it for edit?

Is there a setting for an Access project that allows it to be opened by more than one user at the same time?

 

[Jeff Boyce]

Greg

Have your network gurus check the permissions on the backend location --
everyone who needs to use the application has to have full permissions on
that backend. Access creates a "lock" file (.ldb) to keep track of who's
in. If the permissions aren't right, folks won't be able to open the
application "second" (just the first one in!).