98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - Multiple people in database
Access - Multiple people in database
Resolved · Low Priority · Version 2003
Wed 18 Jun 2008, 16:34Delegate 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:28Trainer 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 information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Choosing data types in AccessNot 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. |
