VBA Modules not running within Access DB

[kwilliams]

Hi,

I have been asked to fix a problem with an old (unsupported) Access DB. The VBA code has disappeared from the module. The server it resides on has Access 2013.

I am trying to recover the DB from an old version that still has the VBA code. But they don't seem to be properly linked to the database.

For example, if I click on a form's properties and then click on the ellipses (...) next to one of the events that shows "[Event Procedure]", I get the error:
"Microsoft Access failed to create the Visual Basic module. If your database is on a network drive, check your network connection, and then try again."

Alternatively, if I open the VBA code by clicking Database Tools > Visual Basic, I can see the code for all the forms. But if I click on a line of code and right-click Toggle > Breakpoint, I get the error "Module not found". And if I click Debug > Compile ... I get "Module not found" again.

If I just open the database the Switchboard form opens but I can see that the VBA code has not run.

I suspect something has changed in the server environment, e.g. MS Access has been upgraded or downgraded, but I have no information to confirm or deny this - the team responsible for server admin cannot tell me anything.

Any help would be greatly appreciated.

Many Thanks,
Keith.

 

[sneuberg]

Sounds like it's corrupt. I suggest trying a compact and repair and if that doesn't help start with a clean database and try importing the objects from this corrupt database.

 

[gemma-the-husky]

copy any databases you use before trying to fix this, as you may possibly further corrupt them in the attempt to fix them.