Security

[Sanjaylml]

Hi,

I have made an MDE application through MS Access 2000. My question is that my Boss has asked me to create a form so that through password, he can protect entire application to avoid (Copy / Deletion etc. etc.).

I know this is possible through security features of MS Access but Boss want to put password for application through form only.

I shall be thankful if anyone guide me on the matter.

Thanks in advance

[Stang02GT]

If your boss is looking for this to be done with a form only then here is a web site that will show you step by step on how to do that. I have used this and got it to work so if you have any questions after looking at this let me know


Click here

[Sanjaylml]

Thanks for your reply.

Kindly give me the address of website through which I can get the code.

Awaiting your response.

Thanks in advance.

[Stang02GT]

Thanks for your reply.

Kindly give me the address of website through which I can get the code.

Awaiting your response.

Thanks in advance.

If you click on "Click here" it will take you to the site.

[Sanjaylml]

I am eagerly waiting for your reply.

[Scott Price]

I am eagerly waiting for your reply.

If you would click on the blue underlined link "Click Here" on Stan's original reply it would take you directly to the site. However, if you don't wish to do that, the url is http://www.databasedev.co.uk/login.html

Regards,
Scott

[Sanjaylml]

This does not serve my purpose. I have already a login form at start-up. You must be aware that despite of having login form at start-up, anyone can get the data copied through creating a new Access file by importing the data through Get External Data Command.

Hence, I want that while accessing table, Password is asked, through form. I know that security feature is available in MS Access but If I implement the same, in that case, twice passwords are required

1) Security feature
2) Login form

Hope, you understand my problem.

Could you help me?

[Scott Price]

The problem with MS Access security feature is that it's not all that secure! Any level of security that you can impose is going to be just a padlock to your data.

I'm not sure if what you are asking is even possible with Access, but I remember a few other questions dealing with the subject on this site. Have a look around on this site and see what some of the others have run into: http://www.thescripts.com/forum/thre...5-padlock.html
http://www.thescripts.com/forum/thre...+security.html

Also, I see that you have posted a nearly identical thread earlier http://www.thescripts.com/forum/thre...+security.html . If this is the same question, kindly don't double post. That just clogs up the forum with meaningless posts, and results in the people attempting to answer your question not knowing what has already been tried or suggested.

Regards,
Scott