Updating Access Db without exclusive access. 3

[newguy86]

Is there a way to update objects in a database without having exclusive access to the database, so that others can use the database and get the most updated version the next time they open the file? What I want to do is whenever I need to update something in my database I need to be able to go in and implement the update and if others are in the database at the time they will still have access to the old setup until they close the file and reopen it, which at that time will display the updated objects.

Any assistance would be greatly appreciated. And if I need to clarify anything just let me know.

Travis

http://www.enterprise.com

 

[Remou]

Databases should be split front-end and back-end, with each user having his or her own copy of the front-end. Updates are make to a 'master' front-end and rolled out to each user. There are a number of ways to do this, and a number of FAQs to match, as far as I recall.

http://lessthandot.com

 

[danvlas]

One of the simplest ways is to write a bat file that actually copies the version from a network drive and then it starts the application

I suggest that you use UNC, not mapped drives


Daniel Vlas
Systems Consultant

 

[missinglinq]

Have a look at Tony Toews hack for doing this with little pain:

http://www.granite.ab.ca/access/autofe.htm

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!