Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2009
    Posts
    21

    Unanswered: Deploying split database to different places/different paths

    I am working on an application that will ultimately be deployed into multi-user situations in 4 separate offices -- i.e., each office will have their own data. I think I have finally convinced the powers that be that we should split our application into a front end interface and back end data. But, I'm not sure how I go about deploying this when I don't know where the files will be installed at each location (i.e., I will not be to require that a specific directory is used).

    Anything from general approach to sample code would be suggested. I hate to ask such an open-ended question, but I'm feeling stumped.

    Thanks!

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I have an auto-connection thing going on -- when the database first opens, it attempts to open one of it's linked tables. If it fails, then it prompts for the back end location and once specified, re-links all the tables.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2009
    Posts
    21
    ok, I found some code here that looks like it will work. But, the poster indicates that relationships are not retained. Is there a better approach you could recommend? Thank you!

  4. #4
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Weird. The tables are related in the back end file. There are no relationships to preserve in the front end, which is where you are refreshing links.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  5. #5
    Join Date
    Jun 2009
    Posts
    21
    duh. good point. Guess I should have actually tried the code before I asked about it. Once again - thank you! I'll give it a shot and see what happens...

Posting Permissions

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