adapt process to multi user environment

Posted on 2008-11-16
Last Modified: 2012-05-05
I have a single user database with a very basic shipping process:
tblPart has a ysn field for "selected" and another ysn field for "shipped".
User select parts to ship.
Then creates the shipment.
A command button executes an append query adds the parts and shipment to tblShipPart and an update query that marks the part as shipped.

I need to adapt my process to a multiuser environment. I could use some points on the adaptations I need to make.

Question by:eliwil
    LVL 77

    Accepted Solution

    You are going to have to change the way you select parts.
    You can't use a field on the parts table for selection, if more than one user could be selecting.

    There are several different approaches you could use.
    A simple one would be to use a separate table to store selections (tblMyParts).
    If you create a continuous form based on this table you could then have a combobox to list the parts and you could select the parts from the list.  You would use this list as the basis of your append query and update query.

    However there is still an issue here because potentially every user is using the same table to store their selections.
    But part of the change for multi-user is to split the database into two files, using the database splitter tool.
    Once split, then  you have a shared 'backend' file called databasename_be, which contains the tables and nothing else and a 'frontend' which contains everything else.  A copy of the frontend goes on each users pc and the backend goes in a shared folder.  It is best to place a copy of the current database into the shared folder first and then do the database split.   That way, the frontend has links to the correct folder established as part of the split.

    In the frontend file, before you distribute it to each user, you delete the link  to tblMyParts and import the table from the backend into the frontend.  This will mean that each user has their own copy of the table and so there is no confusions between selections from different users.

    Author Comment

    Precisely what I needed. Database is already split. So, this is going to be easier than I thought. Thanks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
    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…
    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…

    779 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

    16 Experts available now in Live!

    Get 1:1 Help Now