Securing a database in code

  • Thread starter Thread starter Adam
  • Start date Start date
A

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
 
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.
 
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
 
Back
Top