Need exclusive access

[Mike D.]

I'm looking for a way to get temporary exclusive access
to a networked.

It would be too time consuming to go to everyone's
computer and turn the program off, or even change
everyone's link to another filename. So, I want to
update my MS Access file, without getting the
message "You can't save cahnges. You need exclusive
access."

I've tried deleting the file, wanting to replace my new
one keeping the same filename, but when I try this the
file magically reappears (maybe has something to do with
the lock .ldb file?).

Your knowledge is greatly appreciated.

 

[Douglas J. Steele]

Split the application into a front-end (containing the queries, forms,
reports, macros and modules), linked to a back-end (containing the tables).
Put the back-end on the server, and give everyone their own copy of the
front-end, preferably on their hard drive.

When you want to make a change to the application, and you want everyone to
get the new version, take a look at something like the free Auto FE Updates
Tony Toews has at http://www.granite.ab.ca/access/autofe.htm