I have an 2000Access application which run in several network installations. One of my customers claims that the application is very slow in his network. On the server he has the table database (containing all his recorded data)
I'm encountering a crashing problem (database inconsistency) with a shared Access 2002 database. I've split a DB into a front-end (sales.mdb) and back-end (sales_be.mdb) and there are approximately 5 users logged into the DB at any given time.
I am running an Access 2002 database (split front-end and back-end) and would like to LOCK the database on command (to update tables and avoid crashes for inconsistency). Is this possible? Please let me know, thanks.