Securing a database in code

[Adam]

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

 

[SBD]

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.

 

[Adam]

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