prevent access to VBA and db window

[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 because i have too many objects
(or something like that). what are my other options to prevent users from
accessing the underlying vba code or the db window?

Thanks!

 

[Joan Wild]

Instead of looking for other options, you should fix the problem. There is
no reason a MDE can't be made.

If you use Debug, Compile it will highlight any errors - fix those. Once
you are error free, try the MDE again.

 

[Jesse Aufiero]

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.