Can't Create MDE

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

I design my accdb alot and have no poblenms creating MDE file until now.
Now for
some reason I'm unable to create an MDE.Thi is the help error:

This error is usually associated with compiling a large database into an MDE
file. Because of the method used to compile the database, a considerable
number of TableID references
are created for each table. The Access database engine 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 Access
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.

I have no where near 2048 TableIDs. Maybe 10.

Any help will be appreciated,
James
 
The problem been solved.
Although the db was compiled there was an error which it apparently didn't
catch.
After inserting a remark into a module so the 'Compile mydatabasename'
became available
I re Compiled it and it found the error. I was then able to create a MDE.
Don't know why it didn't catch the error the first time.
Anyway

James
 
Back
Top