Results 1 to 3 of 3
  1. #1
    ChuckColeman1812 is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2010
    Location
    Springfield, IL
    Posts
    25

    Need advice on linking remote offices back to main office

    Hi, I'm using Access that comes with Office 365. I have a customer that has a main office and three remote offices. The three remote offices will have an Access front-end database that I would like to link back to the Access back-end database at the main office. I know I could output new data at each remote office to an Excel spreadsheet format and have it emailed to the main office and then imported into the back-end, (through code on a main office front-end form). That doesn't seem to be the best way and although I can automate several of the steps, it is still steps that I would like to eliminate. If their entries could be made directly into a table(s) that are accessed by the main office, that's a much better way. I thought I saw something about being able to use SharePoint that comes with Office 365 and essentially store some tables in SharePoint that could be accessed by the main office and remote offices. Is this a web database?

    I'm looking for advice and documentation on how others have addressed something like this. The remote office's inputs are fairly small but they occur on a daily basis.

    Any ideas?

    Thank you in advance,



    Chuck

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Access is not a good web database.
    But you can link in the other database via networking. Your Network admin could create server paths to each office and the given folder where the db is.
    Then you can link the db as an external table.
    (or SharePoint too)



  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    or look to use terminal services/citrix at a cost.

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

Similar Threads

  1. Replies: 3
    Last Post: 02-02-2019, 10:28 PM
  2. Need advice on second DB linking
    By vicsaccess in forum Programming
    Replies: 3
    Last Post: 09-11-2016, 02:04 PM
  3. Replies: 4
    Last Post: 03-31-2012, 10:52 AM
  4. Replies: 0
    Last Post: 06-28-2011, 02:24 AM
  5. Data synchronization between two offices
    By Hcasty in forum Access
    Replies: 1
    Last Post: 08-13-2009, 08:07 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