Ken has attended:
Access Introduction course
Excel Intermediate course
Passwords
How do you password protect the data to send by email
RE: Passwords
Hi Ken,
Thanks for your question:
1. Click the Open Database button
2. Select yourdatabase.mdb. Click on the arrow next to the Open button.
Choose Open Exclusive to open the MyNewApp.mdb database with exclusive access. This gives you the sole access to the database when you have it open. You can't set a database password if it's in shared access mode. By choosing the Open Exclusive option, you prevent other users from opening the database whilst you have it open.
3. Choose Tools, Security, Set Database Password to open the Set Database dialog box.
4. In the Password and Verify text boxes, type dbpassword. Passwords are case-sensitive.
Click OK to accept the database password and close the dialog box.
5. Close the database.
6. Test the password to see if it works. Open yourdatabase.mdb. Now you find you must enter the database password in order to open the database.
Type dbpassword, and click OK. Your database opens.
Now you can send the database file as an attachment to your receipent, BUT please note that many email servers are set to reject any files with Passwords so unless this is not the case your files are not going to get through... Pete