MDE file creation error

[Kevin M. Long]

Hello everyone,

I've read through the last couple of weeks worth of posts but I haven't
found anything that resembles the problem that I'm having when trying to
create a MDE file. Here is the background information for the problem that
I'm encountering:

Problem Description:

I have an Access 2002 database that has been split into front and back ends.
I was able to create a MDE file for the front end a couple of days ago,
however after making some design changes to the database (front end and back
end) I now receive errors when trying to re-create the MDE file. Here are
the steps that I'm taking when creating the MDE file:

1) Create a copy of the front end master
2) Open the copy and select Tools | Database Utilities | Make MDE file from
the Access menu

Microsoft Access crashes and the error reporting dialog is displayed. When I
check the location where I wanted the MDE file to be placed, there is a new
database named db1.mdb and another database named Backup of
<frontenddb>.mdb. I checked the KB articles and found
http://support.microsoft.com/default.aspx?scid=kb;[LN];814858 and followed
the steps in the article but it does not correct the problem. Any
suggestions on what could be causing this issue? Thanks in advance for any
assistance that you can provide.

Kevin M. Long
Support Systems Analyst
The University of Arizona

 

[Tony Toews]

Hello everyone,
I have an Access 2002 database that has been split into front and back ends.
I was able to create a MDE file for the front end a couple of days ago,
however after making some design changes to the database (front end and back
end) I now receive errors when trying to re-create the MDE file. Here are
the steps that I'm taking when creating the MDE file:

1) Create a copy of the front end master

You don't need to create a copy of the FE.

If A97 then Ctrl+G to open the debug window >> Debug >> Compile and
Save All Modules.
If A2000 or newer then Ctrl+G to open the immediate window >> Debug >>
Compile.
Fix any errors which pop up.

Or you may have a reference to an MDB which aren't allowed from an
MDE. You must make an MDE out of the referenced MDB and reference it.

I'd suggest a decompile but you've already done that.

Then try importing all your objects into a new MDB.

Tony

--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm