Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    opening a db from a form (Access 2000)

    Is it possible to open another database with a button on a form. Let's say the db I want to open is called c:mydbdb1.mdb. Is this possible? Thanks...

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: opening a db from a form (Access 2000)

    How do you want to open it?
    1. Should it become the current database, i.e. replace the database containing the form with the button? Please be aware that the original database will be closed, and that execution of code in that database ends when the other database is opened.
    2. Should it be opened in a new instance of Microsoft Access, i.e. in another Access window? Depending on the computer this can be a heavy load on resources.
    3. Should it be opened for manipulation in code only?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Posts
    294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: opening a db from a form (Access 2000)

    Option 2 even though it is a resource hog is the option they would like. Is it possible Hans? Thanks... Thanks for the reply on the other post. It was a simple solution.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: opening a db from a form (Access 2000)

    What is the intent of opening a second database? Are they wanting to toggle back and forth between them, or what? If the latter, why not just open both of them the regular way?
    Charlotte

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: opening a db from a form (Access 2000)

    See <post#=289885>post 289885</post#> by MarkD. For Access 2000, replace 'Office10' by 'Office' in the path.

Posting Permissions

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