Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 658
  • Last Modified:

MS Access 2007 password protect

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
Reyesrj
Asked:
Reyesrj
3 Solutions
 
worm-getterCommented:
maybe this tutorial will help you:

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

you could always email mike.

good luck.
0
 
pdebaetsCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
ReyesrjAuthor Commented:
Thanks All,
accdr seems to be the best solution for me.
Thanks again
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now