Results 1 to 4 of 4
  1. #1
    Andyw is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jan 2015
    Posts
    1

    Reconnect to backend

    I have a Access 2010 database that I have split and need to encrypt the BE. The two files will be used by people in other offices and will be saved on different servers. Is there a way I can prompt the user to point to the BE when they first open the FE. At the moment, once it has been saved onto a different server/directory, it can no longer find the BE/

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    You could try google with this as search criteria
    msaccess vba reconnect to backend database

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2000
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I found examples and created my own relinking code. I used examples from many sites including

    The Access Web
    http://access.mvps.org/access/tables/tbl0009.htm

    Rogers Access Library
    http://www.rogersaccesslibrary.com/forum/topic286.html
    http://www.rogersaccesslibrary.com/forum/topic334.html

  4. #4
    NTC is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Nov 2009
    Posts
    2,392
    I provide written set up instructions on how to link to the back end file.

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

Similar Threads

  1. Replies: 3
    Last Post: 01-02-2014, 08:11 AM
  2. Switching backend mdb
    By GraeagleBill in forum Programming
    Replies: 18
    Last Post: 03-23-2013, 03:19 PM
  3. SQL Backend
    By Mclaren in forum Access
    Replies: 1
    Last Post: 11-25-2011, 08:34 AM
  4. Unsecured Backend
    By injanib in forum Security
    Replies: 3
    Last Post: 06-23-2011, 04:34 PM
  5. duplicating backend
    By ls9bg in forum Database Design
    Replies: 1
    Last Post: 03-30-2011, 03:16 PM

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