Very strange..must read....network or DB? 1

[CMooreJr]

OK...all was fine yesterday....ntohing has changed today....but I now have a few reports and forms (not all) that come up with the error when running
"Automation Error" "Catastrophic Error" and the program quits...

I can open the database and go to the specific report and/or form. The ones that give errors have [Event Procedures] on them, BUT NOT ALL! If I try to enter the [Event Procedure] (...) I get a "Access cannot build the Visual Basic Code..." and it quits again...

Even more strange, the report cannot be deleted, renamed, cut or copied without an error. I can rebuild it successfully, but cannot compact it, because it tells me that there are record(s) that cant be read....

Any suggestions here? Hopefully it's a network issue and all will be fine tomorrow, but I can't count on it!

 

[danvlas]

'Network connection may have been lost' (among other messages?)

Access 2000?

MS screwed your code... Try the /decompile switch:
Start - Run
msaccess.exe /decompile "C:\Path\File.mdb"
...it may work (it did for me a couple of times)
Or get the latest backup and see if you can compile the code with no errors (open any module then Debug - Compile).

Needless to say, make a backup before any of these attempts... And make a backup as often as you can from now on...

HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[CMooreJr]

you got it....I searched forever on Microsofts page and found the decompile switch. used it and all is fine. Needless to say, backup every day! (I'm going to see if I can set up an automated backup at 5:00pm after verifying everyone is logged out, and save myself from this again)

Have a star!

Cmoorejr.