Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wkalo
Starting Member
10 Posts |
 Posted - 2005-09-26 : 17:07: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. --------------------------------------------------------------------------------In My Application There 27 Forms 4 of the with Subforms. I Have Removed The 4 Forms And Tried To Create An MDE File It Was Successfull, What Seems To Be The problem In Forms With SubformsThanks In Advance, Your Help Is Very Much Appreciated.....  |
|
|
Ashfaque_Online
Starting Member
6 Posts |
Posted - 2005-09-27 : 07:31:24
|
| Re-complie your code. Surely there must be an error.Once there is no error in code, MDE can be make easily.Ashfaque |
 |
|
|
wkalo
Starting Member
10 Posts |
Posted - 2005-10-08 : 14:27:18
|
| Thank You For Your Reply There Was Error In VB Code MAinly In Date Calculation Thank You Very Much |
|
|
|
|
|
|
|
|
Failure In Creating MDE File