prevent access to VBA and db window

  • Thread starter Thread starter Jesse Aufiero
  • Start date Start date
J

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!
 
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.
 
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.
 
Back
Top