problems with creation of mde file

[Sabine]

Hi everyone,

I've got problems creating a mde file of my mdb Database.
I can specify the database to be changed and name for the
mde file, but then Access tells me that it is unable to
create an mde file.
Does anyone have an idea why that happened? I have
compacted and repaired the database which is now only 1
mb, so the size can't be the reason I guess.
Thanks in advance
Sabine

 

[Nikos Yannacopoulos]

Sabine,

There are two main reasons why creation of an .mde fails,
1. Too many objects in the .mdb (some say more than 500, others raise it to
1000)
2. Some error(s) in VBA code

The most common reason is (2), and (1) is easy to rule out if the number of
objects is quite less than 500. So the code is usually the point to start
checking. To do this, open the VBA IDE (e.g. by opening a amodule in design
view, or pressing Ctrl+G to open the immediate window) and run menu item
Debug > Compile <database file name>. If an error exists in the code it will
be highlighted; fix it and repeat the process until no more errors are
found. Then you will be able to create your .mde (provided the number of
objects is not an issue).

HTH,
Nikos

 

[Guest]

Thank you Nikos!
As the number can't be the problem as I've only got around
30 objects. So I will try to find the error in the VBA
code.