Results 1 to 4 of 4
  1. #1
    sharkey_lsu is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Aug 2013
    Posts
    31

    Online/Offline Interface?

    So I am well aware of using SharePoint lists for storing the backend of my access database but I am curious as to what would be the best method for achieving an offline/online system. The scenario will be such that all of my inspection/client/operator information will be stored on either a local server or using a sharepoint list. However, I will need the ability for an inspector to create and perform an inspection while possibly not having access to an internet connection. Is there some type of synchronize function that can be utilized to achieve this? Any ideas as to where I could possibly download an example of such an interface so that I can learn through disection? Thanks in advance for any advice.

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    You would need local tables of course. The records then must be written to the tables in SharePoint when possible. The idea is not particularly difficult - the challenge would be whether this is done manually by a knowledgeable developer or whether one needs to attempt to make it available to a non technical user which would be a little tricky to design that interface.

  3. #3
    sharkey_lsu is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Aug 2013
    Posts
    31
    Thats about what I had in mind but I would ultimately like the end user to have a sync button that could be pressed when a connection is available. I wonder if this is something that is not often needed? I would think it would be a pretty common need for any database that has the back end stored in a separate location. I would hate to have a useless system if for some reason internet is not available.

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    The issue is going back and forth. Have a version that has local tables, another version that has the normal tables. That is about the best you can hope for.... Even with this you must be very thoughtful in regard to the design and that the correct key fields are managed. The version with local tables is essential input only.....

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

Similar Threads

  1. VPN offline Access data sync?
    By Heatshiver in forum Import/Export Data
    Replies: 3
    Last Post: 07-31-2012, 11:20 AM
  2. Replies: 8
    Last Post: 07-09-2012, 07:19 AM
  3. Access DB working offline
    By snoopy2003 in forum Database Design
    Replies: 10
    Last Post: 02-17-2011, 06:11 AM
  4. offline remote access f/e sql b/e
    By hyperionfall in forum Access
    Replies: 3
    Last Post: 08-23-2010, 09:07 PM
  5. Replies: 1
    Last Post: 10-05-2009, 06:52 AM

Tags for this Thread

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