Can't Open Table in Microsoft Access 2003
I am unable to open one major table in an Access file that I had no problem with on 3/29. When I try to open the table I receive the error message: "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." When I click OK I receive the message "Microsoft Office Access can't open the table in the Datasheet view." I can open all other tables in the file without a problem. The file is on a local machine and is not on a server, so no one else can possibly have access to this file. The only thing I can recall that might have caused this is that on 3/29 when this file was open my computer froze when trying to shut down, so I had do to a hard shut down that day. This is a critical table and I don't have an older back-up of the file. Thanks for helping to open thistable.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
RE: and import all objects (tables, forms, etc) into the new mdb
There is a good chance if the Asker gets to this point (C and R did not work, and no .ldb or not able to delete it), that he cannot import the "corrupt" table into the new db.
shanknomore, if you do create a new db and import all db objects, including the corrupt table, immediately quit the db and make a backup. Go back into your new db and run Tools | Compact and Repair. If you are successful to this point, make a backup and get back to work. :-)
Do not forget your relationships.
Lee
There is a good chance if the Asker gets to this point (C and R did not work, and no .ldb or not able to delete it), that he cannot import the "corrupt" table into the new db.
shanknomore, if you do create a new db and import all db objects, including the corrupt table, immediately quit the db and make a backup. Go back into your new db and run Tools | Compact and Repair. If you are successful to this point, make a backup and get back to work. :-)
Do not forget your relationships.
Lee
Based on the error message, not thinking that the table is corrupt per se ...
In the Windows filesystem, make a copy of the .mdb file.
Open the original db and go to Tools | Compact and Repair
See if that helps.
Open the original db and go to Tools | Compact and Repair
See if that helps.
dugyalasreekanth:
Your post is exactly the same as the first post!
mx
Your post is exactly the same as the first post!
mx
ASKER
Thanks!
If no joy, then create a brand new mdb ... and import all objects (tables, forms, etc) into the new mdb.
Does the issue still exist?
" This is a critical table and I don't have an older back-up of the file. "
I must ask by law ... why ?
mx