Hello,I am facing a situation which is not allowing me to create a .mde file. The following are the details of the file and the environment:Version Of MS Access : 2002Actual Version in which file is created : 97 and then upgraded to Access 2002Current File Format : Access 2002Size of the file : 550 MBThere isn't any problem with the functioning of the database and everything is fine. But recently when I tried to create an .mde file out of it, i found that the database crashes with the typical send information to Microsoft screen.Trouble Shooting Steps Performed:1. Deleting the 10.0 Key which is located under HKEY_CURRENT_USER\Software\Microsoft\Office and then launching MS Access.2. Executing the following commands and then tried recreating the .mde file. MSAccess /unregserver MSAccess /regserver3. Using the Help-->Detect & Repair4. Used the JetComp.exe which generated another copy of the database and then tried creating the .mde file.None of the above steps worked and a short while after i issue(Tools-->Database Utilities->Create .mde file) the create MDE file command, the cursor changes from an hourglass to the normal pointer and then the crash screen comes up.When i select the repair the current database in the crash screen, i find that a new file is generated which when loaded asks for a password (it is a password protected file) and then shows up a message which says VBA project is corrupt.I understand that something in the VBA part is corrupt.As a last try i tried moving all the objects into a new database. Now the new database is in the latest which is Ms Access 2002 format and the size is less. However, when i try creating an mde file, it says Microsoft Access was unable to create mde file.Any help in this regard is highly appreciated.Cheers,Pradeep
|
|
0
|
|
|
|
Reply
|
Utf
|
3/12/2007 12:43:34 PM |
|