Microsoft Access security & encryption

[electra]

I want to develop an Access database and upload it to a website:
If I want to provide a multi-Level user access to the users, is there is any built in feature that i can use?. provide the users will use ASP developed Interface to the database. or I have to build my own security level (coding it)?.

And are there anyway to encrypt the information inside the Database, I mean build in feature in Microsoft Access feature.?

Thanks in Advance...

[willakawill]

I want to develop an Access database and upload it to a website:
If I want to provide a multi-Level user access to the users, is there is any built in feature that i can use?. provide the users will use ASP developed Interface to the database. or I have to build my own security level (coding it)?.

And are there anyway to encrypt the information inside the Database, I mean build in feature in Microsoft Access feature.?

Thanks in Advance...

Yes to both. Encryption and security is built into Access. It is a pain in the butt though. Much better for you to implement a simple login security structure and maintain the login details in the session variables

[electra]

Yes to both. Encryption and security is built into Access. It is a pain in the butt though. Much better for you to implement a simple login security structure and maintain the login details in the session variables

Thank you, May I ask u please to guide me in how to apply the encryption on the database?.

and I Know there is a security tables, such as user groups, Admin groups & so on, do u think its possible to link my ASP user level permission code to the tables, and can u please set me on how to start doing this?. or its tooooo complicated & its better to write my own code of users level access?.

Again ur help are much appreciated.

[willakawill]

Thank you, May I ask u please to guide me in how to apply the encryption on the database?.

and I Know there is a security tables, such as user groups, Admin groups & so on, do u think its possible to link my ASP user level permission code to the tables, and can u please set me on how to start doing this?. or its tooooo complicated & its better to write my own code of users level access?.

Again ur help are much appreciated.

I refer you to my previous post. If you implement your own security structure then you can maintain it from any computer anywhere. If you go down the access user groups route your are in for heartbreak.

[electra]

I refer you to my previous post. If you implement your own security structure then you can maintain it from any computer anywhere. If you go down the access user groups route your are in for heartbreak.

Your advice are considered much appreciated.

[Killer42]

I refer you to my previous post. If you implement your own security structure then you can maintain it from any computer anywhere. If you go down the access user groups route your are in for heartbreak.

Hi willakawill.

Can you, or someone, point us in the direction of a useful reference on setting up a security structure in Access? I have done something very simple along these lines, but that was probably over ten years ago.

This is the sort of link which would be worth posting in a sticky thread. In fact, maybe we should look at setting up a "useful links" sticky thread where we can add things like this.

[MMcCarthy]

Hi willakawill.

Can you, or someone, point us in the direction of a useful reference on setting up a security structure in Access? I have done something very simple along these lines, but that was probably over ten years ago.

This is the best reference I've found. It seems to cover everything.

http://www.jmwild.com/Accesssecurity.htm

This is the sort of link which would be worth posting in a sticky thread. In fact, maybe we should look at setting up a "useful links" sticky thread where we can add things like this.

I know that a useful links page is something under consideration by the site administrator.

In the meantime I'm reluctant to put up a thread as I suspect it will garner replies with inappropriate sites.

Let me see if I can create a thread that can have the replies blocked.

I'll look into it.

Mary

[Killer42]

Thanks mmccarthy, I'll check it out.