Quickie question on multiple users: v2010

scubadiver007

Registered User.
Local time
Yesterday, 18:25
Joined
Nov 30, 2010
Messages
317
How do I change the database for multiple users?

There is no "advanced" option in the options tab.

:confused:
 
Hello,

IT IS possible with Access.. Yes you can have a central DB and have it accessed by several users.. to achieve this, first you need to create a DB with forms that are linked to tables for adding/editing records. Once that is done you can split the database into FrontEnd and BackEnd..

Creating 'FrontEnd' and 'BackEnd' is nothing but splitting the Access file into two seperate files, one file holds all your Forms, Queries, Modules, Reports which we normally term as the FrontEnd. The file BackEnd will contain all the tables that you have in the database.

FrontEnd file can be distributed to as many users as you want, It will have a link to the tables thus it allows concurrent users to access the table, however not the same record at the exact same time.. BackEnd is preferablly placed in a Network location where all users have access to..

Splitting of the DB, it can be done whenever you feel. Personally I would do it towards the end i.e. before distribution of the files, as this will give only one user access over the file, thus avoiding tampering of information until final product is ready to go.

To create a FrontEnd, BackEnd file all you need to do is.. (In Access 2010) Go to Database Tools-->Under the Move Data group you will have three options of one is 'Access Database'. Click it and the magic happens..

ALWAYS MAKE A BACKUP, BEFORE YOU SPLIT. Just in case.

Hope this helps. For more info, visit...

http://www.hitechcoach.com/index.php...atid=24:design
 
Last edited:
Access is multi-user out of the box. You don't have to do anything. However, as the other posters have suggested, splitting the database into a FE (all the forms/reports/queries/code/macros) and a BE (tables only) will go a long way toward giving you a robust solution that is not prone to corruption.
 

Users who are viewing this thread

Back
Top Bottom