database will not open

[Guest]

Please Help even if its bad news!!!!

When I open database "inventory" I automatically get a microsoft crash that
wants me to send the detail report. It states: AppName: MSAccess.exe
AppVer:8.0.0.4122 ModName: VBA 332.dll ModVer: 3.0.0.7019
OffSet:000e9899
But I can open A different database "preinventory" then go and open
"inventory" and all my information is there. I think its a startup problem
but I don't know. Is there any advice you can give me? It sure would be
appreciated.

 

[Allen Browne]

Sounds like some kind of corruption. Try this sequence:

1. Create a new (blank) database.

2. In the new database, uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

3. Import all the tables from the problem database:
File | Get External | Import

4. Close, and make a backup copy at this point. At least this gives you the
data.

5. Open the database, and import the other objects (queries, forms, reports,
....)

6. Close Access. Decompile the database by entering something like this at
the command prompt while Access is not running. It is all one line, and
include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

7. Open the database, and compact:
Tools | Database Utilities | Compact

8. Press Ctrl+G to open the immediate window. Choose References on the Tools
menu. Uncheck any references you do not need, and you may need to check the
box for Microsoft DAO 3.6. More on which references you need:
http://allenbrowne.com/ser-38.html

9. Still in the Immediate window, choose Compile from the Debug menu. Fix
any errors, and repeat until it compiles okay.

At this point, you should have a rebuilt database where the name-autocorrect
errors are gone, the indexes are repaired, inconsistencies between the text-
and compiled-versions of the code are fixed, and reference ambiguities are
resolved.