Access - Multiple people in database

The UK's most regular instructor-led training courses.
Training information: ms+access+courses · Microsoft.access.courses · Microsoft Access Training
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version 2003

Steph has attended:
Access Introduction course

by - delegate Steph [1 post] (2008 Jun 18 Wed, 16:34) Reply

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

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2009 Jan 13 Tue	Bloomsbury	7	book now	£188	£215
2003	2009 Jan 16 Fri	Bayswater	5	book now	£198	£215
2003	2009 Jan 22 Thu	Bloomsbury	5	book now	£198	£215
2007	2009 Jan 27 Tue	Bloomsbury	4	book now	£224	£224
2003	2009 Feb 3 Tue	Southwark	7	book now	£188	£215
2003	2009 Feb 10 Tue	Bloomsbury	8	book now	£182	£207
Full Schedule: See all 58 Access Intermediate course dates. Bookings currently available until 23rd March 2010.

RE: Access - Multiple people in database

by - trainer Pete platinum contributer [868 posts] (2008 Jul 7 Mon, 08:28) Reply

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

· Microsoft Access and Customer Surveys
· Access VBA Training Adds Power to your Databases
· The Benefits of Certified Microsoft Training in Access
· Innovation with Microsoft Access
· Access Database Optimization: First Normal Form

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

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips

Rate this page: