Compiling .mdb File

T

travelerkgd

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!
 
G

George

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" έγγÏαψε:
 
T

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!
 
J

Jerry Whittle

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.
 
T

travelerkgd

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
 
J

John Vinson

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]
 
Top