Solved

MS Access 2007 password protect

Posted on 2013-05-20
4
639 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 75 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 350 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 75 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

808 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