Writing code to secure a database

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
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
Click to expand...


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