Writing code to secure a database

[Adam]

I would like to secure a database with my own VBA code, rather than going
through the security wizard. Specifically, what I want to do is to secure
the database in the same way that the security wizard does: in other words,
to encrypt the database and allow access only to users who log on to it with
user names and passwords as specified in the workgroup information file. I
am happy to set up the workgroup information file manually, and I know how
to fine tune the permissions in code (ie allow or disallow access to
specific tables, forms etc to specific users). The part I am struggling with
is the bit where the database gets encrypted in the first place.

If anyone could point me in the right direction I'd be very grateful.

Many thanks

 

[Jack MacDonald]

Take a look at the documents on the website in my signature.

I would like to secure a database with my own VBA code, rather than going
through the security wizard. Specifically, what I want to do is to secure
the database in the same way that the security wizard does: in other words,
to encrypt the database and allow access only to users who log on to it with
user names and passwords as specified in the workgroup information file. I
am happy to set up the workgroup information file manually, and I know how
to fine tune the permissions in code (ie allow or disallow access to
specific tables, forms etc to specific users). The part I am struggling with
is the bit where the database gets encrypted in the first place.

If anyone could point me in the right direction I'd be very grateful.

Many thanks

=======================================================
Jack MacDonald
remove UPPERCASE LETTERS from email address
Vancouver, B.C. Canada
Info about MSAccess user-level security
www.geocities.com/jacksonmacd

 

[Adam]

Many thanks, Jack, that looks like it will be very helpful.

Adam