Problem opening .mdb file

[mshelley1]

Access 2000
WinXp Pro

Greetings:

I have a small access database that I keep on my thumb drive, the last time I closed it I removed my thumb drive before it finished saving and I got the windows was “unable to save” dialog box. Well, the next time I tried to open it, it would not open; when I click on it, it asks for the password (password protected) but when I enter the correct password “Nothing”. I tried to compact and repair but all I get is the option to browse as though there is no file open.

I have researched but can find no solution. Any help will be greatly appreciated.

thanks

Mickey

 

[joeserrone]

Hello,
As a Virtual Assistant I work with many large databases. I would suggest searching in Google for a good MS Access Recovery tool. I have a feeling your database is corrupted.

The rule # 1 to avoid this is prevention! Make sure you backup your database regularly and make sure every week you compact & repair you database.

If you need any further help with your database needs, please don’t hesitate in contacting us.

Thanks

Joe Serrone
www.joeserrone.com
Virtual Assistant
“Solutions for you Business Needs

 

[The_Doc_Man]

I agree with Joe. NEVER take a thumb drive out of a machine without first shutting it down. Otherwise you corrupt whatever files might have been open at the time. Further, if you tried to repair and that failed, you might have lost the whole database. Expect to spend money to get this fixed - if it is even possible to fix, which it might not be.

 

[boblarson]

Joeserrone:

You need to read this post by the head forum moderator:
http://www.access-programmers.co.uk/forums/showthread.php?t=68868