Problem Opening Database

[Guest]

Every once in a while I encounter an interesting problem. I cannot open
databases that I have created. I will open Access and try to open the file
through the Open execution. If that doesnt work, I move onto the folder to
double click on it. If that doesnt work, I attempt to compact and repair it
from the outside (instead of having the file open). When I have tried all of
these alternatives and nothing happens still, I am out of ideas. Besides
recreating all of the information inside the database, are there alternatives?

Basically, nothing happens. If I double click to open the file, it opens
Access, but doesnt show me a database window or anything. Basically, seems
like I simply opened Access without opening a file associated with it.

I have also tried to open it in Safe Mode by Shift-Clicking, but still I
cant seem to open it.

 

[Arvin Meyer [MVP]]

It sounds like corruption. Here are some solutions:

First, always work on a copy of the database. Working on the original may
make it impossible for a repair service to fix it.

Download a copy of JetComp.exe:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;273956

Try backing up your forms as text with the undocumented SaveAsText
LoadFromText functions:

http://www.datastrat.com/Code/DocDatabase.txt

Also have a look at the Microsoft KB article:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;209137

Then have a look at Tony Toews' Access Corruption FAQ at:

http://www.granite.ab.ca/access/corruptmdbs.htm

for some suggestions. Unfortunately, some corruption cannot be fixed - you
may need to create a new database, import what can be salvaged, and recreate
the rest.

Although it's a paid service, Peter Miller does an outstanding job of saving
corrupt databases. Try this URL:

http://www.pksolutions.com

 

[Guest]

Sorry to say that none of those options helped me. I might have to have my
IT personnel refabricate the information from the previous days.

 

[Guest]

The db might be already open in the memory. End the access task or reboot
your system.