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)

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

On Tue, 26 Aug 2003 09:39:15 +0100, "Adam"
<(E-Mail Removed)> wrote:

>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

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

Adam


"Jack MacDonald" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Take a look at the documents on the website in my signature.
>
> On Tue, 26 Aug 2003 09:39:15 +0100, "Adam"
> <(E-Mail Removed)> wrote:
>
> >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