Cannot access a database file even after splitting

[vandy]

Hi All,

I am working on Access 2003 . I have created a database file and saved it on
the network for users to access. I split the file and placed the mdb and be
file on the network. i keep getting this error and when i view my file on the
network 2 more files with the same name and a lock icon are opened. That
implies that some user is using the file but i want to view it too. How can i
bypass this error and what does this mean.

Could not lock file. (Error 3050)
The operating system will not allow Microsoft® Jet to create a lock file
(.LDB) in the same directory where the database file (.MDB) resides. You need
to have write privileges to the directory that contains the database you are
trying to open. This error can also occur if you are trying to use the
passive shut down/connection control feature while the database is opened
exclusively.

thanks in advance.

 

[Ron2006]

The users should have and be executing their own copy of the FE part
of the application.

AND/OR

Do all the users have FULL rights to the directory on which the
application resides? If not, they MUST.

Ron

 

[vandy]

Hello Ron,

Thanks for your reply. I checked the files access on the network and the
users have
full rights on it.

When i split my table i have the mdb and be.mdb file created. I have got
both the files on the network and the way i am accessing these file is that i
create a shortcut to the mdb file on the netowork and access it.

Is this right. Do you want me to copy the mdb file on each user system and
open it.

Here this particular file is allowing only a single user to log in. When
another user logs in it says cannot lock file and does not open the file.

Another question i have created some security files using the wizard. When i
change my workgroup for a particular db file all the other db files open up
with the same workgroup. Each workgroup has its own set of user access i
thought it was database sepecific. Can some clarify as to how to make each
workgroup specific for a database.
thanks in advance.

 

[Ron2006]

Yes, that is the problem.....

You need to create a copy of the FE on the harddrive for each user.

The only other way would be to have a separate and unique copy of the
FE on the network for each user. It is better if the copy is on their
harddrive.

That should eliminate the problem.

Ron

 

[Ron2006]

Here is Tony's response to the same question posted by someone else:

==========================================
However you really want to put the FE on each machine or place in a
user specific directory on the server. This will help avoid some
weird error messages when users are changing the same forms record
source, filters and such as well as corruptions. It is also much
easier to implement a new version of the database with changed
queries, forms, reports and VBA code.

I specifically created the Auto FE Updater utility so that I could
make changes to the FE MDE as often as I wanted and be quite
confident
that the next time someone went to run the app that it would pull in
the latest version. For more info on the errors or the Auto FE
Updater utility see the free Auto FE Updater utility at
http://www.granite.ab.ca/access/autofe.htm at my website to keep the
FE on each PC up to date.


This utility will also create the shortcuts in the Quick Launch
toolbar, Desktop or Start >> All Programs if desired.


Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/