Results 1 to 3 of 3
  1. #1
    andythepandy93 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012

    Use network and local backend

    Hi all,

    I have a database on my laptop that normally accesses a backend on a local server. However when the laptop isn't on that network I would like the database to switch to a local backend on the harddrive. What is the best way of doing this?
    I was thinking on startup a simple check to see if the network file exists and if not use the local one but I don't know if this is the best way of doing it.


  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    I've done something similar to this before and used a pop-up message box (input box) asking the user to enter N for network or L for local. I set the box to a default of N as this was most common. In the database properties I had paths to the back file for network and local and then re-linked the tables (if required) depending on the choice using the dataabse properties.

  3. #3
    andythepandy93 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Thanks, I hadn't though of asking the user, simple yet effective.


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

Similar Threads

  1. Replies: 1
    Last Post: 05-25-2012, 10:36 AM
  2. Replies: 1
    Last Post: 04-08-2012, 11:42 PM
  3. Creating a local network Database
    By blukit01 in forum SQL Server
    Replies: 1
    Last Post: 03-15-2012, 01:20 PM
  4. Pass Through Queries - Local and Network Tables
    By vinfurnier in forum Queries
    Replies: 1
    Last Post: 03-31-2011, 11:18 AM
  5. Unable to open Access on Local Area Network
    By MikeWaring in forum Security
    Replies: 1
    Last Post: 12-24-2010, 11:46 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