multiple users access

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

Multiple users of access

resolvedResolved · Low Priority · Version 2007

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

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 tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips


Server loaded in 0.08 secs.