Results 1 to 3 of 3
  1. #1
    bogdantheiii is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    2

    How to make a single site multi users application become multi sites?

    My name is Roger, we are 3 guys who have recently developing a CMMS application for Wind Industry in Quebec, Canada.

    We have to make our «multiuser single site Access Application» become multisite. We made it with Microsoft Access 2010. It is installed in Terminal Server so each user opens his own front end but share the back end (data) with others. We are not sure how to accomplish this transition. We are expecting to have to rewrite our queries so the user will determine at logon from witch he is and witch records are his... At the same time, it will be a huge job that we would we would like to avoid doing. We want to keep only one database for all sites because we find it easier to maintain or to apply changes. Some data is shared by everyone and other isn't.

    Is there any method that would make it possible to isolate data for each individual site at login (in the access app.) so we wouldn't have to modify the code and the queries?

    Thanks in advance



  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    No.

    You can leave it up to the user to manually filter records with the intrinsic Access filter/sort tools. Otherwise:

    Modify queries to include filter criteria

    and/or

    Modify Filter property of forms and reports

    and/or

    Modify code to apply filter argument, as in:
    DoCmd.OpenForm "form name", , , "SiteNo='" & Me.tbxSiteNo & "'"

    I expect, if you haven't already, will have to modify at least one table to add a foreign key field for SiteNo, as well as a new table of Sites.

    Will need to modify forms and reports to include this new field as well as this new table in queries.

    I don't see this as a difficult design modification, just need to be careful and methodical in accomplishing.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    bogdantheiii is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    2
    Thanks for answering, you confirm our thoughts...

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Multi users and Split Database
    By cohrsman in forum Access
    Replies: 4
    Last Post: 08-01-2013, 09:13 AM
  2. Multi users login form
    By johnwatkins35 in forum Forms
    Replies: 3
    Last Post: 05-15-2012, 11:39 PM
  3. Switch combobox from multi back to single
    By soulice in forum Access
    Replies: 1
    Last Post: 04-08-2012, 01:18 PM
  4. Multi Users
    By brobb56 in forum Access
    Replies: 1
    Last Post: 09-20-2011, 04:07 PM
  5. Multi Users on shared drive
    By wallen in forum Access
    Replies: 0
    Last Post: 08-25-2008, 08:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums