Results 1 to 2 of 2
  1. #1
    neuroman is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Nov 2013
    Posts
    1

    Open Multiple Databases

    I have one access 2007 database open and wish to write code to call on the click of a command button which would open another access database and bring that one to the foreground.



    I have been trying to use API's nut am not that familiar with their use so have not had much luck.

    All help will be greatly appreciated.

    Thanks a bunch!!

  2. #2
    davegri's Avatar
    davegri is offline Excess Access
    Windows 10 Access 2010 32bit
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,389

    One database opens another

    See the attached database. It contains code that will do what you wish. To see it work, run it. On the form, choose the setup tab. Browse to your target database. Switch back to the compact/repair/backup tab. Click 'Close me and run Target'.
    Your database will open.

    DaveGri
    Attached Files Attached Files

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

Similar Threads

  1. Replies: 6
    Last Post: 10-03-2014, 03:33 PM
  2. Replies: 4
    Last Post: 08-11-2014, 01:18 PM
  3. Replies: 2
    Last Post: 06-20-2014, 12:33 PM
  4. Cannot open any more databases.
    By evander in forum Queries
    Replies: 7
    Last Post: 08-24-2010, 12:22 AM
  5. Cannot open any more databases error
    By Matthieu in forum Access
    Replies: 2
    Last Post: 04-14-2010, 03:29 PM

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