Problem making MDE file

[BenWeber]

When i try to make an MDE file out of my access database, it gives me the
error listed below.

I really would like to be able to compile this so users won't
adapt/modify/whatever the code by hitting f-11 and bypassing the startup form.

The program is a bit big, 46 forms and probably 2/3 of them have modules. I
did check that some are correctly set with HasModule = 0...

The program has linked tables to another database that has the data in it.
I did try compiling that into an MDE successfully before compiling the one
with the code...

Help would really be appreciated!

Thanks,
-B


--- Begin error message ---
Microsoft Office was unable to create an MDE Database.

When i click show help it gives:
This error is usually associated with compiling a large database into an MDE
file. Due to the method used to compile the database, a considerable number
of TableID references are created for each table. The Microsoft Jet database
engine version 4.0 can only create a maximum of 2048 open TableIDs at one
time. Exporting a database as an MDE potentially can exceed this limit if
the database has a large number of objects (table, macro, form, report, etc).
There is no accurate method to estimate the number of TableIDs the Jet
database engine uses during the process of compiling a database as an MDE.
However, each VBA module and each form uses one TableID, as a result, if the
database has 500 forms, and each form's HasModule property is set to Yes, as
many as 1,000 TableIDs are used.

 

[Mr B]

Ben,

I assume that you have compiled your code in your application prior to
attempting to create the mde.

If not, try that first. This will find any code errors. I know that the
error you are receiving does not sound like this is the problem, but I
thought it was worth looking at.

 

[BenWeber]

Uhm, i'm new to access and here's where it shows.

Compile? I didn't know there was a place to do that... How do you compile
your code in the application?

Do you mean compact and repair? I did that and did convert it to
2002/2003.......

Thanks!
-B

 

[Nikos Yannacopoulos]

No, it's not that. Open the VBA environment (Alt+F11) and execute menu
item Debug > Compile [YourDatabaseName] (top item). This process should
highlight any problems in the code that prevent Access from producing
the .mde file. Once the errors are corrected you should be OK.

Note: this is one of two possible reasons for this kind of problem. The
other one is too many database objects, but that's very rare; in most
cases it's the code errors, so start there.

HTH,
Nikos

 

[BenWeber]

Awesome, thanks. This was it exactly.

And thanks Mr B too, i can't believe i never noticed the compile option.

 

[BenWeber]

Also just wanted to mention how impressed with Microsoft i am in that error
message. I've never seen a programming environment where compile errors
weren't displayed at ALL when there are some during executable creation.

And i've been developing since 1987

-B