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
--
Adam
(remove 'nospam.' from email address to reply)
|