ACCESS Closes Before I Can Fix Anything

[venturifx]

I'm running Access 95 (os is Win98) and recently tried to open an inventory database that I keep. While I can open the other databases listed, when I try and click on the inventory one, it immediately shuts down Access. Thus, if it's corrupted, I can't try to repair or transfer my data out as I can't even get into the database. Any suggestions?

 

[DougP]

Yes<br>
Create a brand new .MDB<br>
Open it<br>
Click the Tables tab<br>
right in the white space of Table TAB<br>
click on &quot;Import&quot;<br>
Find your corrupted database<br>
you can usually import All Tables Queries or anything that does not have VBA code<br>
you can select multiple items<br>
I suggest you pick a few items then save your new database periodically<br>
Or you will crash it too.<br>
<br>
After you have all well<br>
Make a .MDE thsi will prevent future corruption<br>
Click &quot;tools Menu<br>
Database Utlities<br>
Make .MDE<br>
There is another post a way back on .MDE's<br>
<br>

 

[seaport]

Create a new blank database and try importing all objects from the inventory database into the blank database. If this works, you can work on the new database and get all your data.<br>
<br>
<br>