470,647 Members | 1,219 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

best way to gain exclusive access in multi-user environment

hello,

i have a split ms access database with front ends distributed to several users. it is a real pain to have to wait until everyone signs off for the day to make design changes to the backend. i was wondering what techniques people have used to gain exclusive access to the backend when tables, modules, etc. need to be saved/edited. i have seen several clever methods but am not enamored with any yet.

thanks in advance for the help!
Oct 11 '07 #1
3 2422
nico5038
3,080 Expert 2GB
This will only work when all users "have left" the database.
There are ways to close the database by force, but I'm more in for the gentle way the Access Cookbook uses. There they have an internal message system to warn and ask the users on forehand to logout.
Checkout the index and samples at:
http://www.oreilly.com/catalog/accesscook2/
Select CDROM for the samples.

Can recommend the book :-)

Nic;o)
Oct 11 '07 #2
This will only work when all users "have left" the database.
There are ways to close the database by force, but I'm more in for the gentle way the Access Cookbook uses. There they have an internal message system to warn and ask the users on forehand to logout.
Checkout the index and samples at:
http://www.oreilly.com/catalog/accesscook2/
Select CDROM for the samples.

Can recommend the book :-)

Nic;o)
i don't see that link on the page or that subject in the table of contents but if you say it's got what i need i'll go purchase tomorrow.
Oct 11 '07 #3
nico5038
3,080 Expert 2GB
Checkout chapter 10 the sub 08: "Track which users have a shared database open" and sub 04 "Send messages to other users without using email"
In the CDrom section you can download all chapter 10 samples and the sub indicates the name like 1004.mdb and 1008.mdb.

Having warned the users gives them the time to stop working and allows you to use the system's task manager to kill the Access excution after a certain warning time...

Nic;o)
Oct 11 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

38 posts views Thread by kbass | last post: by
16 posts views Thread by D Witherspoon | last post: by
3 posts views Thread by Uwe C. Schroeder | last post: by
reply views Thread by Wayne | last post: by
reply views Thread by bill yeager | last post: by
reply views Thread by MSDN | last post: by
12 posts views Thread by Elmo Mšntynen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.