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

Posted on 2011-05-03
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
    LVL 77

    Expert Comment

    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

    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

    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

    Courses: Start Training Online With Pros, Today

    Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

    Join & Write a Comment

    Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now