Securing a database in code

I would like to secure a database with my own VBA code, rather than going
through the security wizard. Could anyone point me in the right direction
please?

Many thanks

--
Adam

(remove 'nospam.' from email address to reply)

You need to define what you mean by security more
compeletly. There are a number of things you can do.
Generally, what I do is capture the users network logon ID
and compare that to a table with access rights. that table
would have fields for user name, login ID, and access
level. I then use a DLookup to check their access level
and setup access to forms and menus based on it.

Scott<>
>-----Original Message-----
>I would like to secure a database with my own VBA code,
rather than going
>through the security wizard. Could anyone point me in the
right direction
>please?
>
>Many thanks
>
>--
>Adam
>
>(remove 'nospam.' from email address to reply)
>
>
>.
>

Sorry, yes I should have been more specific.

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.

Adam


"SBD" <scottgem@yahoo.com> wrote in message
news:018601c3680c$f534f290$a401280a@phx.gbl...
> You need to define what you mean by security more
> compeletly. There are a number of things you can do.
> Generally, what I do is capture the users network logon ID
> and compare that to a table with access rights. that table
> would have fields for user name, login ID, and access
> level. I then use a DLookup to check their access level
> and setup access to forms and menus based on it.
>
> Scott<>
> >-----Original Message-----
> >I would like to secure a database with my own VBA code,
> rather than going
> >through the security wizard. Could anyone point me in the
> right direction
> >please?
> >
> >Many thanks
> >
> >--
> >Adam
> >
> >(remove 'nospam.' from email address to reply)
> >
> >
> >.
> >