Password Protect Forms

I have several forms in a database. I want to password protect two of these. How can I do this? I have heard I can use VB in the two forms to prompt a password parameter like box and if entered correctly, it allows the user to continue, and if not, it does not let them. Is this possible?

Desperity Seeking Easier Security then Workgroups

Sponsored Links:

Related Topics

Password protect a form
How can I password protect access to a form? I have a public database that all employees use however I only want certain people to be able to view/edit one of the forms in it.


Password Protect Forms
I am using switchboard to allow my co-workers to access their data that I keep up to date for them. I am needing to password protect the two forms that I have to enter and edit data allowing them to use the forms to display and print their data. Is there a way to do this?

I have placed a no addition, deletion or editing on the display and print Forms. But I am wanting to keep them out of the Enter and Edit Data Forms


[MSACC2010] Password protect backend?
I have a database built using MS Access 2010 which is a split database. Everything is working fine until some users found out the BE location. *Someone* then managed to change some user details in the tables. Luckily I have backups but I really want to prevent this happening again.

I noticed there is an option to password protect the BE but will this also mean users will have to enter a password when connecting from their FE? If so, are there any other alternatives to keep the BE safe? I was thinking of a simple login form on opening the DB but ultimately this can also be bypassed plus it's a lot of effort just to password protect the BE.

This is a fairly large company so I just wanted to make sure before I commit any changes.


readonly password protect
How do I put a read only password on access 2007? But still allow others to sort different forms, without being able to edit them


Make your own CODE to lock the database objects
securing the database objects have different ways:
1. Password protect the database
2. Password protect the VB codes
3. Disable allowbypasskey
4. Make MDE file for versions 2003 and previous
5. ULS

MY PERCEPTION:

a. the simplest way to protect is by password protecting
b. Allowbypasskey diabling is a protection done by vb code
c. by making the MDE file, the forms, report, dap, macro, and modules are locked thereby it cannot be opened for editing or for opening.
d. by making ULS, the objects are locked by access, I think this goes by code again and we setup its password.

MY CONCLUSION:
Therefore, protecting the database objects were done thru coding matched by password. So therefore, maybe there is a way that we can make our own CODE to lock the database objects.And I think our gurus here in this forum might help us out with that code.Can we do this?


Password protect form
So I have an 'admin' form that I need to password protect. I can think of a couple different ways to do this(without user level security, which I'm not prepared to do)

Any recommendations?

The form will be access via a switchboard. Better yet, if I could password protect a certain switchboard, than I could put admin items on that board.


SQL Database Password?
With your help thing are working out real good with sql server 2008. Now I'm confused with the password thing.
Can I protect each database with different password? Or do I just protect the initial login Server Password only?


Password Protect an Email Attachment in Access 2007
I am trying to password protect an attachment (in pdf) which is to be sent on a monthly basis to different employees. Actually it is a payslip. Is it possible to protect and open such an attachment?. I want to use a combination of employee name and employee id to open the attachment. I am using outlook for emailing purposes.

Please let me know on a possible solution for this


Creating password protect form
I've an 'admin' form that I need to password protect in Access 2010. I can think of a couple different ways to do this(without user level security, which I'm not prepared to do) Any recommendations?

The form will be access via a switchboard. Better yet, if I could password protect a certain switchboard, than I could put all admin items on that board.


Import forms to another db
I have one locked mdb file. When I import the objects like table, querues and forms. I can import all apart my all forms. It shows "microsoft helps protect this visual basic for applications project with a password.

You must supply the password in the visual basic editor before you can perform this operation" can anybody update me how I can resolve this issue.


Import forms to another db
I have one locked mdb file. When I import the objects like table, querues and forms. I can import all apart my all forms. It shows "microsoft helps protect this visual basic for applications project with a password. You must supply the password in the visual basic editor before you can perform this operation" can anybody update me how I can resolve this issue.


Password Protect an Email Attachment in Access 2007
I am trying to password protect an attachment (in pdf) which is to be sent on a monthly basis to different employees. Actually it is a payslip..

I want to use a combination of employee name and employee id to open the attachment. I am using outlook for emailing purposes.


What should I do to protect Ms Access (.MDB ) file?
I have developed a small desktop application using visual basic 6 and Ms Access 2003 as back end. Database is password protected and contains sensitive data. As many password retrievaltools are available, What should I do to protect Ms-Access (.MDB )


Password Protect an Access Database
Password protecting an Access database allows you to protect your sensitive data from prying eyes. In this tutorial, we walk you through the process of encrypting your database and protecting with a password, step by step.


Password Protect Buttons on Forms
Is it possible to set security on just a button on a form?
Example, I have a switchboard, and I would like it so that if one was to click on a button on the switchboard it will require a password to function.

If it is possible could someone show me an example of code for an onclick event


Password Protect Buttons on Forms
Is it possible to set security on just a button on a form?
Example, I have a switchboard, and I would like it so that if one was to click on a button on the switchboard it will require a password to function.

If it is possible could someone show me an example of code for an onclick event?


import/export of forms with VBA code password
I'm trying to import a form from an older version of a database in an effort to keep from building it from scratch again. When I try to import from the new or export from the old I get an error message that says "Microsoft helps protect this Visual Basic for Applications Project with a password. You must supply the password in the Visual Basic Editor before you can perform this operation.


import/export of forms with VBA code password
I'm trying to import a form from an older version of a database in an effort to keep from building it from scratch again. When I try to import from the new or export from the old I get an error message that says "Microsoft helps protect this Visual Basic for Applications Project with a password.

You must supply the password in the Visual Basic Editor before you can performthis operation"

I have the VBA editor open, with the correct password!


Password Protect Autoexec
Is there a way to password protect the autoexec macro? If not, how would I go about securing that macro? I've noticed that you can import the autoexec macro to a blank database, manipulate the autoexec (i.e. disable shift-key bypass) and export the autoexec back into the database.

Note: the database is already split into FE and BE and both are password protected. The code is already password protected. I thought my system was secure but a friend whom I challenged to break into it was able to get to my code.

He confessed to manipulating the autoexec file so how is a guy supposed to secure his access system now


How to protect our access database?
How can we hide the left pane and make the tables, queries and reports password protected so that user is only able to work with forms? Moreover I want forms to be only used and be protected from being re-designed.