I am not able to open database in access2003 because of error 3197.
Everytime when trying to open ,the same message appears on the screen:
"The Microsoft Jet engine database stopped the process because you and another person are attempting to change the same data at the same time".
I have tried to import that file in the new database,but that doesn't work. Even when my copy the database on other machine, same error message come up. Some one suggested it might have to do with enabling the database for multiuser access but i can't even open the database.
Does anyone know how to open the database with error 3197?
I've run into this one before too. It could be indicative of file corruption. Sorry for that. Best solution for that is to restore it from a backup.
You can also try deleting your .ldb file for your database and see if there really is someone else trying to use it. If the file isn't there or lets you delete it, then the database isn't open. If the system denies you the ability to delete the file, then someone else on your network has it open.