Solved

MS Access 2007 password protect

Posted on 2013-05-20
4
648 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

632 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