Desperate Help Request

[CptTom]

How do resolve this error?

The Visual Basic for Applications project in the database is corrupt

I need to resolve this quickly to keep the system up. I am getting errors in most of my queries & reports that worked just fine last Friday. Sometimes, I can run the query behind a report just fine but the report comes back saying "No longer connected to the network", it should not be looking for a network.

I tried copying and it copied with. I tried exporting each module, report, form, etc to a new front-end, and that is when I received the VBA error message. My project code will not copy over, or the name shows up in the project view screen but contains no coding.

Larry

 

[Namsha]

Hopefully you made a backup? I can expect anything and everything of myself;
But can only accept or reject what you have to offer!

 

[CptTom]

What caused the errors, I have back-ups. If I am only setting this up to happen again real soon by bringing back the back-ups, I have accomplished little.

 

[Namsha]

Just a thought here but what engines did you use in your original VB project maybe it doesn't or hasn't adopted the same engines? Like Access if you need to use a certain library you need to access it through references. I can expect anything and everything of myself;
But can only accept or reject what you have to offer!

 

[Namsha]

I would have to look at it in order to understand what you are talking about......here is my email if you are interested. cheytj@kear.tds.net send some form of it zipped up.

Nina I can expect anything and everything of myself;
But can only accept or reject what you have to offer!

 

[Namsha]

Larry.....It is looking for those linked tables in the other database and that is why it is having some issues. It may be that you have a virus in the computer or the database program is funky for some reason or another. I have had the same problem with mine it gets persnickety. Try to repair and compact and if that doesn't help then reinstall Access, with all the bells and whistles and see if that doesn't help. Let me know I am going home. I can expect anything and everything of myself;
But can only accept or reject what you have to offer!