Can I Do Several Logins/Passwords

[Christopher Lusardi]

What do you think about using Visual Basic's dataset capabilities or
use Access directly? I used an earlier release of Access. Does the
current release of Access allow several users with login IDs and
passwords?

Thank you,
Christopher Lusardi

 

[John Vinson]

What do you think about using Visual Basic's dataset capabilities or
use Access directly? I used an earlier release of Access. Does the
current release of Access allow several users with login IDs and
passwords?

Thank you,
Christopher Lusardi

As with all versions of Access back through 2.0, you can define an
arbitrary numbers of users (each with their own ID and password), and
categorize the users into Groups. Each user - or better, each group -
can have multiple levels of control on every table and other object in
the database.

The security model is fairly complex and must be applied with care.
Download the Access 2000 Security FAQ (it hasn't changed with later
versions) from

http://support.microsoft.com/kb/207793/en-us

and study it CAREFULLY. It's not hard to set up security wrong, so
that any knowledgable person can bypass it easily, or so that
*nobody*, including yourself, can get into the database!

John W. Vinson[MVP]

 

[Christopher Lusardi]

The security model is fairly complex and must be applied with care.
Download the Access 2000 Security FAQ (it hasn't changed with later
versions) from

http://support.microsoft.com/kb/207793/en-us

and study it CAREFULLY. It's not hard to set up security wrong, so
that any knowledgable person can bypass it easily, or so that
*nobody*, including yourself, can get into the database!

Can I create an interface to Access that will have buttons to take me
to one of several sub-processing levels: [A] (1) add login ID, (2)
Delete User, (3) Change password. Add entry to database, [C] Change
entry in database, [D] Delete entry in database [E] Print out report?

Will the book "Microsoft Office Access 2003" give me enough information
to do what I want? Do you recommend any other books?

Also, do you think that Visual Basic release 8 can do a better job than
Access 2003, why or why not?

Thank you,
Christopher Lusardi

 

[Christopher Lusardi]

The full title of the book that I have is "Step by Step Microsoft
Office Access 2003"

Christopher Lusardi