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