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
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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
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.
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
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.
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?
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)
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.
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.
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
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?
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.
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.
There are two parts to the following video tutorial explaining how to password protect the back end of your Microsoft Access database where your first need to split the database and then exclusively open the back end database to apply an encrypted password. You can also manually link and re-link tables from other databases which will in turn need to be individually password protected should you require the added protection for the more sophisticated system.