MS Access 2003 - Failure to create MDE file: error VBA is corrupt?
- by Justin
Ok so this is a brand new snag I have run into. I am trying to launch a new MDE from my source MDB file, and it is locking up Access.
So in my mdb, I am first compacting and repairing, and then selecting create a new mde (just as I have done many times before).
It looks like it is starting the process, but never gets to where it compacts when it is done, and access is not responding. So after I force close the app, I look in the folder where I am trying to create the MDE to and I see there is a new access db1 file there.
If I try to open that it gives me an error that says file not found, and then it says the Visual Basic for Applications is corrupt.
The thing is, I just made a very simple adjustment to the code since last launching an mde, and after this I double and triple checked it...its not that because its just a simple open this form and close this one addition.
I did however have my source mdb file on a disc that I copied to my laptop, and then tried to re link the tables to the network drive (had them linked to other tables on my local drive so that I could develop offline)??
PLEASE HELP!!!