 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Security / January 2007prevent access to VBA and db window
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.  SignatureJoan Wild Microsoft Access MVP > 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! 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. > Instead of looking for other options, you should fix the problem. There > is no reason a MDE can't be made. [quoted text clipped - 8 lines] >> >> Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.