Secure logon

[shiller via AccessMonster.com]

Experts,

I'm trying to secure my database by creating username/password for users
because the built-in security function in Access does not meet my requirement.


What's the best way to go about doing that?

Can you recommend any resources?

Thanks.

 

[Douglas J. Steele]

I'm not really sure what you're looking for! What "built-in security
function" are you talking about if not Access User-Level Security (which
involves creating usernames and passwords for each user...)

Some resources are:
Microsoft Access Security FAQ Available in Download Center (Q165009)
http://support.microsoft.com/?id=165009
Microsoft Access Security FAQ Available in Download Center (Q207793)
http://support.microsoft.com/?id=207793
Frequently Asked Questions About Microsoft Access Security for Microsoft
Access versions 2.0 through 2000
http://support.microsoft.com/support/access/content/secfaq.asp
Security Whitepaper (written for Access 2.0, but explains the concepts)
http://support.microsoft.com/?id=122036

 

[Chris O'C via AccessMonster.com]

Upsize the tables to SQL Server and use Windows authentication. That's
secure and doesn't require the users to log into the app because their
Windows logon has already accepted their user name and password when they
booted the pc.

Use Books online (BOL) for documentation, it installs with SQL Server. SQL
Server Express is free if your budget's tight.

Chris
Microsoft MVP