Invalid Data Format - corrupted??

[AmberO]

I'm really hoping that someone can help me.

This morning my access 2000 database has decided to freeze on certain forms. When I go into design view and open the code, I get "Invalid Data format". I can't compile my code (which was fine on friday).

I have no idea how this got corrupted, but the compact and repair functon does not help.

I set the has module property to no thinking I could replace the code, but when I try to I get the message "Microsoft access failed to create the visual basic module '|' "

If you have any ideas at all about how I could fix this, please post me a reply, as I'm at a loss!

Thank you.

 

[vandewi]

Try creating a new, blank database. Import all of the objects from the original (including links). Compile and compact the new database. I have had a great deal of success with this method.

Make sure all of your users realize that they must shut the database down properly (no right clicks on the menu bar, or three fingered salutes). Improper shutdowns are the number one cause of database corruption.

 

[AmberO]

Thanks for your suggestion - I thought it might end up being the case.

The only thing is that this database has five replicas in remote offices and I don't really want to have to recreate the whole field of databases. Does anyone know if I have any other options??

 

[zyl]

Hi,

Why not try a popular Access database recovery tool called Advanced Access Repair to repair your Access MDB file. It is a powerful tool to repair corrupt or damaged Access MDB files.

Detailed information about Advanced Access Repair can be found at http://www.datanumen.com/aar/

And you can also download a free demo version at http://www.datanumen.com/aar/aar.exe

Alan

 

[Dennisk]

you could also try Jetcomp available as a free download from M$. this is slightly more powerful then the repair option in Access.

 

[dfenton]

Your application should be split and only the back end (i.e., tables) should be replicated. Jet Replication simply doesn't work reliably over the long run with front end objects (forms/reports/modules).