can't make MDE

[Jesse Aufiero]

When I attempt to turn my access 2003 mdb into an mde i am informed by
access that it cannot perform the operation. What are my other options to
prevent users from
accessing the underlying vba code or the db window?

This is the exact error that I get when attempt to make the mde...

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.


Thank you!

 

['69 Camaro]

Hi, Jesse.

When I attempt to turn my access 2003 mdb into an mde i am informed by
access that it cannot perform the operation. What are my other options to
prevent users from
accessing the underlying vba code or the db window?

You should convert the database file to an MDE database file to protect the
code, just as you tried to do. Please check the "Can't make an MDE!"
checklist on the following Web page to help you determine why you can't
create the MDE database:

http://www.Access.QBuilt.com/html/conversion.html

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.