View Single Post
Old April 7th, 2004, 10:46 AM
sal sal is offline
Friend of Wrox
Join Date: Oct 2003
Location: Clarksville, TN, USA.
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts

What you do is keep a master of the front end database somewhere else (not the shared drive), then make all changes to this master and replace the front end file as needed. The best thing to do is to put the front-end file on the user’s pc. Just make sure to lock that front end and throw away the key when you distribute it By the way, I did not mean by using Access security).

The best thing to do as far as database back end is to use MSDE or SQL Server.

and to answer the question, no, you would still be locking the database.