Error Message "Could Not Lock File"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

For some reason, a db I developed got corrupt but I was able to save the data
and recreate it. This is a shared db and I thought I recreated the
permissions the same as the previous db. This is being shared across a
network from my local machine and was working fine before. If I have the db
open, no other users can open it. They get the message "Could not Lock File".
I have sharing enabled for the db but this keeps coming up. If someone else
opens the db, I can still open it fine.

Any suggestions are welcome. Thanks.
 
Hi, Howard.

Since you have a multiuser environment, you need to avoid using the
operating system's security permissions to secure the database file and the
directory where this database is located, because many of the users may be
prevented from opening the database or using certain tables. For more
information on methods to avoid these problems, please see the following Web
page for a link to the article, "Multiuser Databases":

http://www.Access.QBuilt.com/html/articles.html

In a multiuser environment, it's best to split the database into a front end
and back end, place the back end (tables and relationships) on a shared
network drive (your local machine is okay, but a server is better) and place
a copy of the front end (forms, queries, reports, modules, et cetera) on
each user's workstation, with links to the tables in the back end. This
setup helps prevent database corruption and cuts down on network traffic,
among other benefits.

For more information on split databases, please see the following Web page:

http://www.Access.QBuilt.com/html/gem_tips.html#SplitDB

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Thanks Gunny. Got everything back up and running again. Your article was well
written and very informative!

Thanks again,
Howard
 
Back
Top