Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

passwords

ResolvedVersion 2003

Ken has attended:
Access Introduction course
Excel Intermediate course

Passwords

How do you password protect the data to send by email

Edited on Thu 27 Nov 2008, 09:38

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

Wed 3 Dec 2008: Automatically marked as resolved.

Access tip:

Hiding Multiple Table columns

If you want to hide non-adjacent Access table columns. In Datasheet view, open the table that contains the columns you want to hide.

On the Format menu, click Unhide Columns.
In the Unhide Columns dialog box, clear the check box next to the name of each column you want to hide.
Click Close.

This method makes having to use the Hide Columns command repeatedly unnecessary

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.