Access Database Crashes When Creating An .MDE File

[Guest]

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 : 2002

Actual Version in which file is created : 97 and then upgraded to Access 2002

Current File Format : Access 2002

Size of the file : 550 MB

There 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 /regserver

3. Using the Help-->Detect & Repair

4. 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

 

[Allen Browne]

A decompile will probably fix this:

Try this sequence (in order):

1. Uncheck the boxes under:
Tools | Options | General | Name AutoCorrect
Explanation of why:
http://allenbrowne.com/bug-03.html

2. Compact the database to get rid of this junk:
Tools | Database Utilities | Compact/Repair

3. Close Access. Make a backup copy of the file. Decompile the database by
entering something like this at the command prompt while Access is not
running. It is all one line, and include the quotes:
"c:\Program Files\Microsoft office\office\msaccess.exe" /decompile
"c:\MyPath\MyDatabase.mdb"

4. Open Access (holding down the Shift key if you have any startup code),
and compact again.

5. Open a code window.
Choose References from the Tools menu.
Uncheck any references you do not need.
If you have DAO selected, make sure it's DAO 3.6, not 3.51.
For a list of the ones you typically need in your version of Access, see:
http://allenbrowne.com/ser-38.html

6. Still in the code window, choose Compile from the Debug menu.
Fix any errors, and repeat until it compiles okay.

 

[Guest]

Wowww,

That has done the trick. The mde file got generated and it works fine.

Thanks a lot, Allen!!!

Cheers,

Pradeep