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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » Setting security

Setting security

ResolvedVersion 2003

Wed 8 Jul 2009, 16:18 Delegate Ian said...

Ian has attended:
Access Advanced course

Setting security

Can you set security without closing the Access data base

Fri 10 Jul 2009, 16:45 Trainer Carlos said...

RE: Setting security

Hi Ian

If you want to password protect a database it must be opened "Exclusive".

So if you haven't done this you need to close the Database and open it as Exclusive. To do this:

1. Click the Open button
2. In the Open dialog box select the required file.
3. Click the arrow next to the Open button
4. Select Open Exclusive

Hope this helps.

Regards

Carlos

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

Setting security

Setting security

RE: Setting security

Access articles

Access tip:

Hiding Multiple Table columns