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" <(E-Mail Removed)> wrote in message
news:018601c3680c$f534f290$(E-Mail Removed)...
> 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)
> >
> >
> >.
> >
|
Similar Threads
