Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2006
    Posts
    17

    Post Unanswered: Multiple databases with one front end

    I am trying to enable my user to access 5 different copies of a single database from one front end.

    Each database contains tables, queries, etc and works the way it should do individually, but i want to be able to split the databases into one frontend and with each seperate backend.

    The reason i want to be able to do this is to enable the user to open one front end but to be able to select which back end they are going to use.

    Is there any way to do this?

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You can use the RefreshLink method of the TableDef objects in the front-end.
    Have a nice day!

  3. #3
    Join Date
    Mar 2006
    Posts
    17
    Thanks for you your quick reply.

    I've not had a chance to fully read up about the refreshlink method, but from what i understand does this mean that i would have to refresh the link for each indicidual table or could i just specifiy the backend file?

  4. #4
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    You have to refresh the link for each table. You can use a function such as:

    Code:
    Dim dbs as DAO.Database
    Dim tdf as DAO.TableDef
    
    Set dbs = Currentdb
    For Each tdf in dbs.Tabledefs
        if Len(tdf.Connect) Then
            tdf.Connect = <New connection string>
            tdf.RefreshLink
        End if
    Next
    Set dbs = Nothing
    Have a nice day!

  5. #5
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,424
    Provided Answers: 8
    Been there done that there a lot of work to be done where you could just put 5 shortcuts on the desktop
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  6. #6
    Join Date
    Mar 2006
    Posts
    17
    ... it does seem like a lot of work, just to make it easier for the user to only open one file. Thanks for your help guys

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •