Help with Security!

[Cyberix]

Hello,

I'm trying to create a database with a security (user level) feature for one database that I will make run-time and give to someone else. Is there a way to do this? Either in macros or VBA?

Thanks for any help you can provide.

 

[Cyberix]

Didn't fully explain. I need different levels of user security on only my database application. It should not affect Microsoft Access in general, just my database application.

Is this possible?

 

[Travis]

If you don't want to use MicroSoft Access's security by creating your own System.MDW an other method you could use is simply to make a User Table with the Users Name/Password/Security Level.

When they open the app you can have them login and if successful set a global Variable = to the Security level. Now you will need every part of your app that is security sensitive to check this variable to verify that they are Cleared for access.