Results 1 to 9 of 9
  1. #1
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50

    Cool Multiple connected Database and relative Paths

    Hello,



    I am busy with developping a DB. However I would like to use multiple backend DBs and one Front end DB. However I get an error "Cannot connect to Multiple Databases"

    Next thing is: would it be possible to create relative paths to the Back end Database from the Front end?

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    not come across that error before, and never had a problem connecting to multiple back ends. What is your setup?

    using access 2013? client based (i.e. vba) or web based? what type of backends? how are you trying to connect? etc

  3. #3
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    Many thanks so far. I think the second question is most important now. I intend to use Runtime where, during the installation process, the user can define its own drive on which the DB will be installed. In my case the Front end and back end will be in the same folder but the exact path is not known.
    So would it be possible to connect the fromt and the back end with a relative path?

  4. #4
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    yes - you can determine the path to the front end in vba using currentdb.name - from that you can determine the relative position if you have defined it

    Alternatively, assuming backend is an access db use filedialog for the user to point to the backend location

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    Also, I presume this is for a single user - front ends should be installed on each users machine - they should not be sharing a network based front end.

  6. #6
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    Yes the back end is an Access DB. I am not familiar how to implement this. Will have to do some research on the net. Any suggestions for interesting sites?

  7. #7
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,399
    just google 'vba filedialog' you will find the MS help pages and other threads with similar questions

  8. #8
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    Hello again. I have tried the option of the FileDialog. But does not provide what I am looking for. I wil go ahead with the solution found here:

    http://stackoverflow.com/questions/5...folder-changes

    Many thanks

  9. #9
    MrDummy is offline Advanced Beginner
    Windows 7 64bit Access 2013
    Join Date
    Sep 2015
    Posts
    50
    This worked for me. Thanks for the replies

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

Similar Threads

  1. Replies: 2
    Last Post: 11-23-2015, 06:40 PM
  2. Replies: 2
    Last Post: 11-03-2014, 02:36 PM
  3. Replies: 4
    Last Post: 01-30-2014, 12:18 PM
  4. How to use database when not connected to network?
    By justhininabouti in forum Database Design
    Replies: 5
    Last Post: 03-21-2012, 02:49 PM
  5. Replies: 0
    Last Post: 03-06-2012, 10:32 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