The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Setting security

Resolved · Low Priority · Version 2003

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

Setting security

Can you set security without closing the Access data base

For upcoming training course dates see: Pricing & availability

ReplyFri 10 Jul 2009, 16:45Trainer 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 articles

· How To Use The New Navigation Form In Access 2010
· Get A Head Start With Access 2010 Templates
· How To Successfully Design An Access Database For A Paying Client
· Access Corruption Avoidance Tip #2: Avoid Dangerous Data
· How To Create Navigation Forms In Microsoft Access

Please browse our web site to find out more about
access database microsoft training and other Microsoft training courses.

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000

View all Access hints and tips

Hi guys,

At work I need to set up certain recurring meetings on a monthly basis.

I have found that Outlook will let me choose a recurrence of "day 4 of every month" etc, but I need mine to recurr on a certain WORKING day of every month -..

» Forum post: Recurring meetings - excluding weekends

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions