Failure In Creating MDE File

wkalo

Registered User.
Local time
Today, 14:52
Joined
Sep 14, 2005
Messages
42
hi There
I Have A Database Trying To Convert It To MDE I Get The Following Message
--------------------------------------------------------------------------
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.

Any Help Please
Thank You In Advance
 
In My Access Application There 27 Forms Where 4 Of Them With Subforms
I Tried And Deleted All Form With Subform And Convert To MDE Was Successfull,
Where Do you Think The Problem In Forms With Subforms
 
wkalo or anybody. I am having this same exact problem, I did a search on this forum and found this thread. What did you do resolve this?
 
Hi There
If You Have VBA Script It Is Very Important To Compile Your Work Before Making And MDE File

If You Still Have A Problem, Please Attach Your Work And I Will Try To Find The Problem, But The Above Did Work For Me.....


Good Luck !!!!!!!
 
Hi wkalo,
Access can get stubborn on occasion. I would start a new, blank db and turn off Name Auto-Correct and turn on Compact on Close then close it. Open it again and import everything from the other db then close the new db. Then open it again and compile the db and close again. Then open and see if it can create an MDE at that point. Good luck. You can also try a /decompile.
 
Thanks Wkalo. I complied my work and my MDE was created fine :)


Hi Rural guy, just out of curiosity: how do i decompile? and what does that do?

ps: have you been hiding from my radar? :D
 
Mornin' MsLady,
Not hiding on purpose. I've been pretty busy on several projects and not able to put in much time on the forums as of late. I would *never* hide from a Lady! :p

Here's a link that explains the /decompile pretty well. http://www.granite.ab.ca/access/decompile.htm
 

Users who are viewing this thread

Back
Top Bottom