How do i set up mutiple users for data entry in Access

Posted on 2011-05-03
Medium Priority
Last Modified: 2012-05-11
I have a client that has designed a form for data entry , we have access 2007 but not mutiple licenses.  I want to assign three people for data entry.  How can I do this we have an xp server and peer to peer cabilities
Question by:angelfly2525
  • 2
LVL 77

Expert Comment

ID: 35513645
You will have to install a version of Access on each user's machine.
This could be the runtime version whch is available as a free download from MS.
However, unless the application has been designed to operate entirely through designed  menus/ribbon options the users may not be able to get to what they need to.  In the runtime mode, the only things the user will see are what  the developer have designed; there are no standard Access menus or ribbons.

Author Comment

ID: 35514065
Can I use runtime to work from a central databse ?  I did not want to combine data entry files from separate computers?
LVL 77

Accepted Solution

peter57r earned 2000 total points
ID: 35514211
The correct configuration for a multi-user Access application is to use a 'split-file' set up, as follows.

In the developer copy of access , open the database and use the Move Database ribbon (Access)  to split the database into a backend which just contains tables and a frontend which contains everything else.
Do this split on a COPY of the current database which has been placed into a shared folder. This folder will hold the backend file (which will have '_be' added to the name) after the split.
The frontend (same name as the original database) should be copied to each user's machine and run from there using either a full copy or the run-time version of Access.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question