Create .accde file get error

[Richo]

When I click on the "Create ACCDE file" button I get the following error
(there a page to change the name, then click ok)

Microsoft office Access was unable to create the .accde, .mde or .ade file

with a SHOW button was says
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.

Do you know how to get around this error?
What I am trying to do is create the DB so a user can use it! How do I do
that and creating an .accde file is this the right way to do it??

Thanks

[Tony Toews [MVP]]

Post by Richo
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.
Do you know how to get around this error?

That's a very misleading message. There is almost certainly a VBA
code error. Compile your project to locate any such errors. Ctrl+G
to get to the Immediate Window then Debug >> Compile.

Tony

[Richo]

Thanks for that, I have lots of issues with the 2007 version that I am
working on. I nned tp sort out before I compile.
Can you tell me how to compile a 2003 version so I can give it to another
user and use i.e when they click on it the welcome page is displayed.
It has been a while since I used Access and Access 2007 has changed.

That would be great if you could help to compile and get using what I have
created.(2003 version)
--
Regards

Richo

Post by Tony Toews [MVP]

Post by Richo
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.
Do you know how to get around this error?

That's a very misleading message. There is almost certainly a VBA
code error. Compile your project to locate any such errors. Ctrl+G
to get to the Immediate Window then Debug >> Compile.
Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
Granite Fleet Manager http://www.granitefleet.com/