Test to see if Access DB is available and repair an Access 2000 database that has active connections
$30-100 USD
Închis
Data postării: circa 22 ani în urmă
$30-100 USD
Plata la predare
I'm looking for 2 code snippets that will solve some data-crashing problems I'm having running an Access 2000 db on a 6 computer peer-to-peer network. First off, sometimes when 2 folks simultaneously try to connect to the same table, there is an error and the database gets corrupted and I get an error stating the database is in an unrecognizable format. If I disconnect all users and repair the database, it then works again, until the next data crash (I assume this is the problem). I want code that will test the connection I want to make and see if somebody else is connected, and if so, sleep a few milliseconds before trying again. Also, and if this isn't really possible, I want code that will let me repair an Access 2000 db while others are attached, or will disconnect all other users and let me then repair it. The database is locked at the database level with the code "a123". Can this type of stuff be done?
## Deliverables
Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. Complete copyrights to all work purchased.
## Platform
win 98 and up