By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,827 Members | 2,220 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,827 IT Pros & Developers. It's quick & easy.

Giving Password protection for a Database

P: 7
How can I Build a opening Password (i.e. while opening the database it will prompt for a password) ?
Jul 17 '07 #1
Share this Question
Share on Google+
3 Replies


P: 65
How can I Build a opening Password (i.e. while opening the database it will prompt for a password) ?
Open the database execlusive. Go to Tools | Security | Set Database Password. There enter the password for the database twice and then close it. When you open it again the database will ask for the passwor.

Abolos
Jul 17 '07 #2

damonreid
Expert 100+
P: 114
You can also make it so that multiple users can log into the database. To do this you need to make a security file (a Microsoft Office Access Workgroup Information file) and point a shortcut at both the database and the Workgroup file.
Make a new shortcut in the format:
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "Location of your database\database name.mdb" /WRKGRP "Location of your workgroup file\workgroupname.mdw"
Jul 17 '07 #3

P: 65
How can I Build a opening Password (i.e. while opening the database it will prompt for a password) ?

if you are going to use damonreid's method, then it is good to backup the file before starting the mdw wizard.

abolos
Jul 26 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.