Can't Create MDE

[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

 

[JamesJ]

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