Hi John,
Your problem is that you have the same application being used by
multiple users at the same time. The standard practice is to place the
backend on the server and each user has their own copy of the front end.
This will prevent a variety of headaches. The only hassle with this
practice, of course, is when you have to update something on your
application.
VB2005 (VB.Net) has a real nice deployment feature that lets you deploy
anything you want, an MDB application, ADP, excel, word, jpg file... It
is called "Click Once" deployment. The only catch is that it requires
Sharepoint server to be running and IIS.
You can also write a VBscript file in Notepad and call it from a
shortcut on each User's desktop (I had to do this before Click Once).
The VBscript file would check the server to see if there was an updated
version of an mdb front end. If yes, then copy it to the calling
workstation and overwrite the old one. If no, then just start up the
mdb app on the calling workstation.
The other alternative is to manually, go to each workstation and copy
your updated app to it. Even if this is a hassel, it is way less of a
hassel than the problems you encounter by having multiple users using
the same application. When Access says it supports multiple users, they
mean multiple users can use the backend simultaneously - pull data,
edit, update data. Not the front end.
Rich
*** Sent via Developersdex
http://www.developersdex.com ***