Compiling .mdb File

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello:

We're creating a stand-alone database application in MS Access and do not
want users to see the code. How would we compile this file? Thanks!
 
Dear friend,

If you mean the VBA code, then two ways to do that:
1) Create an mde file (Tools-Database utilities - make mde)
2) Secure your VBA code with a password (Tools- Macro - Visual Basic Editor
- Tools - YourDatabaseName Properties - Protection tab, Lock project from
viewing and set a password.

Hope this will help

George

Ο χÏήστης "travelerkgd" έγγÏαψε:
 
Thanks George:

So I take it this will also keep the tables and other database components
from being seen as well? Thanks so much!
 
Neither of George's suggestions will keep users from seeing tables and
queries. For that you'll need to go with User Level Security which is quite a
PITA. Go to Microsoft's web page and download the security white paper. Read
it twice. Go exactly step by step or you will leave holes in the security.

Another option would be to convert your forms and reports to Data Access
Pages and just allow users into the database through a web interface. Then
you could keep the users out with just a database password.

Third, and often the most practical, is to reevaluate the need for such
tight restrictions on the end users.
 
Jerry:

We did the Data Acess conversion & was successful!

One other question - would you know how to increase table field size beyond
the 255-character limit!

Thanks!

KGD
 
One other question - would you know how to increase table field size beyond
the 255-character limit!
Click to expand...

Use a Memo datatype instead of Text. Note that this does have
limitations - you cannot index a Memo; if you sort or group by the
memo field it will truncate it to 255 bytes; you can't use it in
Joins. But for data that is just to be displayed or searched (assuming
you don't mind the search being a bit slower) it's fine.

John W. Vinson[MVP]
 
Back
Top