Access 2003 Nightmares

[Alan B. Densky]

I have a large Access accounting system that runs perfectly in all versions
of Access including 97, 2000, 2002. It runs perfectly in A 2002 Format
under A 2002. However, when I try to run it under A 2003 I can't even open
a module. I keep getting error messages that it is corrupted. I can't
compact and repair it, as the error message suggests, because it just keeps
repeating that it's corrupted (which is BS).

Has anybody run into this problem, and if so, how did you fix it. Are there
any KB articles on it? This is totally frustrating.

Thanks in advance.

Alan B. Densky

 

[Allen Browne]

Using the previous version, decompile a copy of 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"

Then compact:
Tools | Database Utilities | Compact/repair.

If it still does not work at this point, get Access to rebuild the database
for you by following the steps for the first symptom in:
Recovering from Corruption
at:
http://members.iinet.net.au/~allenbrowne/ser-47.html