Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MS Access 2007 password protect

Posted on 2013-05-20
4
Medium Priority
?
657 Views
Last Modified: 2013-05-20
Hi All,

Could someone show me how to password protect my database so users could access the form but not access the anything on the back end or be able to change / alter the form.  Also to disable so they can't see the tables.  I know how to hid  the tables but I don't want anyone to unhide the tables without a password.

Thanks in advance.
0
Comment
Question by:Reyesrj
4 Comments
 
LVL 6

Assisted Solution

by:worm-getter
worm-getter earned 300 total points
ID: 39180686
maybe this tutorial will help you:

http://databases.about.com/od/tutorials/ss/passwordprotect.htm

you could always email mike.

good luck.
0
 
LVL 12

Accepted Solution

by:
pdebaets earned 1400 total points
ID: 39181203
Try having Access run your database in runtime mode. you can do this with the /runtime switch on the msaccess.exe shortcut or change your database filename extension to .accdr.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 300 total points
ID: 39181326
What you have asked for here involves several different techniques

The kicker with "Locking down" an Access database is that if the developer forges the password, you can lock your self out of the database.
...and these systems can be hard to maintain, especially when you start to need things like:
User permissions (read-only, edit, delete, add)
Distribution
Multiple developers
Multiple users
Split databases
support for different versions of Access
Sandbox mode
Macro security.
...etc

In any event, do a search of "Lock down Access database" here of on the web for lots of useful techniques
0
 

Author Closing Comment

by:Reyesrj
ID: 39183367
Thanks All,
accdr seems to be the best solution for me.
Thanks again
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question