URGENT HELP NEEDED. VB Corrupt

[Kempes]

Hi all,

Big problems on access 2003.

When opening my live db, the message

"The Visual Basic for applications project in the database is corrupt."

I've had a quick search but can't find a solution.
This db has always been access 2003 (Not converted from prior file version).
I can't even import into a blank db as the same error occurs.

HELP!

 

[Geoff Convery]

Hi Kempes, I have the following thoughts
A) It's silly but have you tried compacting and repairing a copy of the corrupt database?
B) Is your live database split so that the front end contains the code and the back end contains the data
C) If it is do you have an up to date backup of the front end?
If that's the case then restoring the front end from the backup should sort it out.
D) If the database isn't split then maybe you can import the tables from a copy of the corrupt database to a new database (using the import facility in the new database rather than the export facility in the old one). This could then become the back end for a new implementation of the database as a split database. All you have to do then is to split a restored version of the live database (or a suitable version of the test version) link this split front end to the new back end and you should be OK with a bit of luck. In my experience split databases are much more resistant to corruption and, if corruption occurs, are easier to resore to full working order.

 

[Kempes]

Thanks for the reply.

I have tried and failed to compact/Repair. This throws up the same error.

Fortunately the db sits on a controlled Server and has been restored.(Albeit a day out of date).

I haven't split the db. This may be a good idea based on what you said.

Now I have it a working copy of it again, I am very worried about a re-occurance. Any idea on what would have caused this issue so I can take preventative action for the future? (A bit general I know but I would like to learn a bit more about this error).

Thanks again for your response.