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.

Sponsored Links:

Related Topics

How do I protect my database?
I created the database by using Microsoft access 2007-I’m a new user of this software. I also save this database in my desktop. One of my employees will take this desktop with him during the weekend just for emergency case. How do I protect my data in the database or is there any ways that I can lock my database? He plans to buy a new computer and I don’t want him to copy my entire database in his new machine.

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 )

[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.

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.

Protect from Delete
I have a database on a network drive. IS there a way to protect the database from being deleted?

Protect from Delete
I have a database on a network drive. IS there a way to protect the database from being deleted

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.

How to protect a database in VB
I am about to start developing a program that downloads a database, and accesses the data within it. I need to somehow protect the data within the database so it cannot be copied, or misusedby other companies who can get the information within the database.

So I need a way that the database can be downloaded from a server (Updated regularly), used by the program, but at no stage be able to be opened, copied etc by the user.

How can I do this in VB?

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


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?

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

Protecting backend table data
I split a database and password protected the backend and relinked them to the front end of the database. After learning that access stores the backend pw after it has been entered I've been trying to find a way to protect the table data.

Is there a way to make the tables read only? or make users re-enter the backend pw everytime they try to access the tables?

PS Why did the program dev's set up '07 like that?! I'm so confused Why pw protect a backend if access just stores it

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.

Access - Open Document / Protect
I'm trying to figure out how to open a Word doc from Access, populate certain fields, then protect the document from editing (just allowing form entry).

All of this is relatively simple, opening the document and populating the fields. The problem comes that you cannot populate the fields in a protected document, therefore, the document must be unprotected.

Then, because the control has passed to Word, I cannot figure out how to protect the form from my Access VBA code.

Locking down your Access Database
How do I protect my Access database? Experienced developer's always suggest placing the database outside of the web root. Most developers suggest that you get a real Relational Database Management System...

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.

how to protect queries and VBA code against stealing
We are designing a database which has several queries and vba codes. We don't want anyone to view the queries or steal them as it is proprietary information.

What is the best way to password protect the queries and VBA codes and still letting the users to use the database.

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

Saving back end
how do you protect the back end database from users? when you give them front end you have to share the back end so their forms be able to update it, but meanwhile users themselves have access to the back and and are able to remove it, how do you protect the back end from manual modification

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

Add a password to an Access switchboard item or to a file within the MDB?
Is there a way I can password protect a switchboard button/item? I don't want to set up multiple users for my database as that is a tedious process for what I need this for.

For instance:
I have 3 users that need to access everything on the switchboard, and 20 users that only need access to 3 of the 7 buttons. How do I password protect those 4/7 buttons that I don't want the20 looking at?