Results 1 to 3 of 3
  1. #1
    dref is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jan 2010
    Posts
    55

    work offline & update database

    Hellos,
    I need to develop a simple database. Install it on server but i should be able to work offline(home) and update the database on the server. Were two users. How can i go about it? It's a split db-backend & frontend. Basically, it's working offline and then update my data on a multi-user database.
    Thx

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Its not totally clear whether you will be updating the FE or the BE.
    Doing this with the FE isn't an issue

    In general, updating a network BE database offline is a recipe for something big to go wrong at some point.

    If you must do so, the server version needs to be locked to prevent anyone else updating any records whilst you are working on the db at home

    Then when you have finished updating the backend:
    EITHER replace the old BE on the server with the updated copy
    OR run a series of update queries to update the server version with your own - then UNLOCK the server BE again

    Whichever method you choose ALWAYS make a backup first

  3. #3
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Maybe SQL server express on Azure can solve your problem.
    http://searchsqlserver.techtarget.co...press-on-Azure

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

Similar Threads

  1. MS Access Shared Database and Offline Files
    By jlgray0127 in forum Access
    Replies: 1
    Last Post: 06-27-2017, 12:14 PM
  2. Replies: 4
    Last Post: 12-06-2014, 08:49 PM
  3. Replies: 0
    Last Post: 08-28-2014, 12:45 PM
  4. Update where query, why does it not work?
    By joris in forum Queries
    Replies: 10
    Last Post: 05-18-2012, 01:26 AM
  5. Synch database after offline update
    By snoopy2003 in forum Database Design
    Replies: 0
    Last Post: 02-21-2011, 11:40 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