Access - Multiple people in database

Resolved · Low Priority · Version 2003

Wed 18 Jun 2008, 16:34 Delegate Steph said...

Steph has attended:
Access Introduction course

Access - Multiple people in database

How can I make it so that only one person can access the database at any one time?

Mon 7 Jul 2008, 08:28 Trainer Pete said...

RE: Access - Multiple people in database

Hi Steph, Welcome to the forum, thank you for your post, in answer:

Access is opened as a multi user program, to do what you ask it is necessary to open the program in this manner;

Open Access program,
Click File>Open, Navigate to your chosen database and select it (single click) in the Open File dialog box, at the bottom corner is the Open button, the Open button has a drop down option, in the drop down option select Open Exclusive.

You now have the database open exclusivly, this is a temporary solution and will only be in force as long as the database is open.

As I said at the beginning, Access is by default a multi-user progam, still I hope that has helped, if so please click the resolved link, regards Pete

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips