Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Thanked 0 Times in 0 Posts

    Query a table in another Access database (Access 97, SR2)

    I am trying to figure out the best way to bring information from one Access database into another. One database has a query that creates the information that another user needs to make use of in another Access database. I would prefer to make this so that the second database can run the query in the first database and have the results placed into an existing table in the second database. Any thoughts or suggestions are certainly welcome and appreciated. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Query a table in another Access database (Access 97, SR2)

    Put the same query in both databases and link the source tables for it. If this is a make-table query, the table will be created in the database it's run from by default.

Posting Permissions

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