Missing VBA Project

[Fear Naught]

I have a database that I need to make some changes to for the users. Users all use an MDE file on another part of the servers and don't have access to the MDB that I use for development.

On opening the file I get the attached message about not being able to read the VBA Project contained withing the database.

The database is in 2003 format but I am using 2010 for changes now.

Can anybody help please?

Thanks.

 

[RuralGuy]

Do you still have Access 2003 to test with?

 

[Dairy Farmer]

Convert the DB to 2010.
Distribute the DB with Runtimes.

Users only need Runtimes installed not Access, so if those users only have 2003 but have Runtimes installed, they will still be able to use a 2010 DB.

 

[RuralGuy]

Convert the DB to 2010.
Distribute the DB with Runtimes.

Users only need Runtimes installed not Access, so if those users only have 2003 but have Runtimes installed, they will still be able to use a 2010 DB.

2010 is compatable with 2003 so that seems unnecessary at this point.

 

[Galaxiom]

On opening the file I get the attached message about not being able to read the VBA Project contained within the database

That is a classic database corruption indicator. You might need to revert to a backup.

 

[Fear Naught]

Do you still have Access 2003 to test with?

Tested with Access 2003 and got the same error. :-(

 

[Fear Naught]

That is a classic database corruption indicator. You might need to revert to a backup.

I do have a previous version but without the latest mods and backups but have no idea how long it has been corrupted. Will get IT Support to check their backups I guess.

 

[Galaxiom]

This might be more trouble than it is worth but worth a thought.

The database itself is probably OK. If you have made substantial changes to forms and reports you could consider combining the current database design with the VBA from a backup. Then you would only have to reimpliment the VBA changes.

However you may have to reconnect the objects with the code by clicking the event property.