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

access multiple people

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - Multiple people in database

Access - Multiple people in database

ResolvedVersion 2003

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?

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

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

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.13 secs.