Quick Links ▼

Bookmark page

Printable version

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

Forum home » Delegate support and help forum » Microsoft Access Training and help » Multiple users of access

	98.1 % recommend us
	More live stats...

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

Training information:

Multiple users of access

Resolved · Low Priority · Version 2007

Reply Thu 2 Jun 2011, 15:44Delegate Maria said...

Maria has attended:
Excel Advanced course
Access Intermediate course

Multiple users of access

Does Access allow auto update of info while more than 1 user is working on the DB? Thanks

For upcoming training course dates see: Pricing & availability

Reply Wed 8 Jun 2011, 09:47Trainer Stephen said...

RE: multiple users of access

Hi Maria

Thanks for your question.

It is indeed possible. To do this you split the database into two parts. A back end which contains just the tables, and a front end which contain forms, queries, reports etc. You then make multiple copies of the front end, one for each user and use the link table tool to create links to the back end.

There is a wizard to do this, and it is covered on our advanced course.

This method allows simultaneous access for up to 20 users at any 1 time

Regards

Stephen

Tue 14 Jun 2011: Automatically marked as resolved.

Access articles

· Convert a Paper Trail to a DBMS
· Access Corruption Avoidance Tip #1: Split Your Database
· How To Create Your Own Access 2007/2010 Navigation Pane
· MS Access can promote teamwork
· An Essential Guide To Using The Northwind Database In Access 2010

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

Access tip:

Using the Quick Access Toolbar in Access 2010

The Quick Access Toolbar is included in virtually every Office product, including Outlook 2010, Word 2010, Excel 2010, and PowerPoint 2010.

You will find the Quick Access Toolbar in the top-left side of the window. To begin, click the Customize button (it's the little black arrow at the end of the toolbar).

Simply click the commands you want to include.

Virtually any command can be added to the Quick Access Toolbar. Click the More Commands option and a new window will open from where you can browse the commands including those not on the ribbon.

View all Access hints and tips