Hello, i had front end using Access, and back end using SQL SERVER. i just move the new front end to new server. I had problem, it happened several times. Can you give me help?
The database '\tetnat\Database\Certification\Certification.mdb' needs to be repaired or isn't a database file.
You or another user may have unexpectedly quit Microsoft Access while a Microsoft access database was open
Do you want Microsoft Access to attempt to repair the database?
yes ? No?
Anybody give me suggestion, it didn't happen in anther server.
Another thing, i found if anybody close the database, The shortcut that "Microsoft Access Record_Locking Information" is still there, i check the sql server, there is no any people log in this database, so i have to manually delete this before i update.