Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need an easy way to open another DB from Current o (A2k SR-1)

    I am quite clueless and would appreciate any advice.
    I want to allow the user to open another database from the one I created so that they may create reports, forms, etc. I must frequently update/Revise the front end and so their reports can't be stored there, or they would be lost anytime I sent them an update. Thanks in advance for any help, Michael

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need an easy way to open another DB from Current o (A2k SR-1)

    Here is a link to a site with a free Access97 or 2000 add-in that is supposed to do what you want: (http://www.trigeminal.com/index.asp?1033) without the parentheses. I have another possible solution for you: If you have a user who wants to create their own custom forms and reports, but they need to use the tables in an existing database, why not simply give them a front end, that only contains links to those tables? Then they can design their own queries, forms, and reports. If they must use some of your reports, they could use your front end when necessary (two shortcuts, one to your original front end, that you continue to modify as you see fit, and a second shortcut to their front end, that they control).

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need an easy way to open another DB from Current o (A2k SR-1)

    You could always insert a hyperlink that points to the other DB

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  4. #4
    New Lounger
    Join Date
    Sep 2001
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need an easy way to open another DB from Current o (A2k SR-1)

    Thanks to both of you!!! I have been working on this problem for a few months & now have the solution because guys like you took the time to help! Thanks again, Michael

Posting Permissions

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