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.
shanknomoreAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

lee555J5Commented:
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.
Lee
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Is there an LDB file in the folder with the MDB (with the mdb closed)? If so, try and delete it.

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
0
lee555J5Commented:
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
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Based on the error message, not thinking that the table is corrupt per se ...
0
dugyalasreekanthCommented:
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.

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
dugyalasreekanth:
Your post is exactly the same as the first post!

mx
0
shanknomoreAuthor Commented:
Thanks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows XP

From novice to tech pro — start learning today.