Setting security

Resolved · Low Priority · Version 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:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips

Setting security

Setting security

RE: Setting security

Access articles

Access tip:

Compact database automoatically