By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,747 Members | 1,389 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,747 IT Pros & Developers. It's quick & easy.

Cannot make mde

P: 22
Hello guys...!
Can you help me i can make mde file . the respond is error....?
Sep 28 '06 #1
Share this Question
Share on Google+
3 Replies


100+
P: 143
Can you be a little more specific, what exactly is the error message?
Sep 29 '06 #2

P: 22
this my error....

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.

More information about this error message online.
Oct 18 '06 #3

P: 8
this my error....

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.

More information about this error message online.
Unless you have an enormous database by Access standards, this is probably a red herring.

It is much more likely that there is a compile error somewhere in your code or a query. Also check for corrupt tables and rebuild indices
Oct 19 '06 #4

Post your reply

Sign in to post your reply or Sign up for a free account.