Encoding Big Access 2007 database?

[rodvaN]

Hello there, Im trying to encode my database so the VBA I used cannot be watched in the future.. But it gets me an error saying I cant encode it.. I click in more help and displays this:

This error is usually associated with compiling a large database into an MDE file. Because of the method used to compile the database, a considerable number of TableID references are created for each table. The Access database engine 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 Access 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.

What can I do for protecting it ?

 

[Mr. B]

rodvaN,

Is this a split applicaltion? Do you have a front-end that you want to make into an mde and a backend that holds only your data (tables)?

 

[rodvaN]

Yes it is a split application.. I got a backend on a server and the frontend in my computer.
Will appreciate very much the best ways to protect my programming from being decoded.

 

[boblarson]

Go to the VBA window and go to DEBUG > COMPILE

If it shows you any errors you need to fix them before you can create an mde/accde file.