making a MDE file

when i try to create a MDE file i get the following error message. Can anyone
help or point me to someone who can?

Thanks

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.

Make sure the code compiles and the db is in the same db file format as the
version of Access you're using. For instance, Access 2003 won't make an mde
out of an Access 2K format mdb. You'd need to convert it to Access 2002-2003
db format first and then convert that to mde.

Chris
Microsoft MVP


csumb wrote:
when i try to create a MDE file i get the following error message. Can anyone
help or point me to someone who can?

Thanks

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1

Although it appears that 2007 will make an mde file from a 2003 formatted mdb
file.

I had this problem too, but as soon as I cleaned up a couple of code
segments that didn't compile properly, it worked OK.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.



"Chris O'C via AccessMonster.com" wrote:

Make sure the code compiles and the db is in the same db file format as the
version of Access you're using. For instance, Access 2003 won't make an mde
out of an Access 2K format mdb. You'd need to convert it to Access 2002-2003
db format first and then convert that to mde.

Chris
Microsoft MVP


csumb wrote:
when i try to create a MDE file i get the following error message. Can anyone
help or point me to someone who can?

Thanks

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.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1

It will crash in Access 2003 whenever it encounters Access 2007-only vba.

Chris
Microsoft MVP


Dale Fye wrote:
Although it appears that 2007 will make an mde file from a 2003 formatted mdb
file.

I had this problem too, but as soon as I cleaned up a couple of code
segments that didn't compile properly, it worked OK.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1

I checked and it has been convertied to 2003,
But it still will not work i still get the same error message, any other
Ideas?

thanks

"Chris O'C via AccessMonster.com" wrote:

It will crash in Access 2003 whenever it encounters Access 2007-only vba.

Chris
Microsoft MVP


Dale Fye wrote:
Although it appears that 2007 will make an mde file from a 2003 formatted mdb
file.

I had this problem too, but as soon as I cleaned up a couple of code
segments that didn't compile properly, it worked OK.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1

Did you confirm that it will compile?

In the VBA editor window, select the Debug - Compile menu option. If it
doesn't compile, it will highlight the code segment that is failing. Keep
doing this until it compiles completely (the Compile option will be disabled
when it has compiled properly). Then try making the mde again.

Dale

"csumb" wrote in message
...
I checked and it has been convertied to 2003,
But it still will not work i still get the same error message, any other
Ideas?

thanks

"Chris O'C via AccessMonster.com" wrote:

It will crash in Access 2003 whenever it encounters Access 2007-only vba.

Chris
Microsoft MVP


Dale Fye wrote:
Although it appears that 2007 will make an mde file from a 2003
formatted mdb
file.

I had this problem too, but as soon as I cleaned up a couple of code
segments that didn't compile properly, it worked OK.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1

Yes that did it thank you very much
after i compiled and made it into a mde file
how do i get rid of the tool bar at the top?

"Dale Fye" wrote:

Did you confirm that it will compile?

In the VBA editor window, select the Debug - Compile menu option. If it
doesn't compile, it will highlight the code segment that is failing. Keep
doing this until it compiles completely (the Compile option will be disabled
when it has compiled properly). Then try making the mde again.

Dale

"csumb" wrote in message
...
I checked and it has been convertied to 2003,
But it still will not work i still get the same error message, any other
Ideas?

thanks

"Chris O'C via AccessMonster.com" wrote:

It will crash in Access 2003 whenever it encounters Access 2007-only vba.

Chris
Microsoft MVP


Dale Fye wrote:
Although it appears that 2007 will make an mde file from a 2003
formatted mdb
file.

I had this problem too, but as soon as I cleaned up a couple of code
segments that didn't compile properly, it worked OK.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/200809/1