Results 1 to 6 of 6
  1. #1
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185

    Exporting /Importing one select query to another database

    Hi all,



    I am in a situation currently where I have to wright a new report that involves 3 databases. I made a select query and I am trying to import the query to the new database where I will be adding more information to that query. I would like to know though what is the most up to date way to do this. I want to eventually every time someone clicks a button on a form that the query runs and selects the most up to date information. Do I need to instead of importing to link the tables by making my select query its own table but that still makes me nervous because how do I know that data from my linked table is up to date? Is there a way to make sure the data in the other database is always up to date?

    Thanks,
    Nick

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Queries do not need to be refreshed, they are always "real time" and will always pull the most up-to-date information at run-time.

    You can show the data from one database in another database by using Linked tables. The queries in both databases then can run against the exact same data tables (so if data is entered in one database, it will also be evident from the other through the linked table).

    Does that answer your question, or I am not understanding something?

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Is it not possible to use 1 split database and deliver 3 front ends?
    if not,
    make a macro to export the query to the other 2 databases.
    then just run the macro.

  4. #4
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    Well I think this will work best if I just link the tables that I need and import the query. Then append the query to the new table by using a macro that is attatched to the button. Does this seem like a good way to go?

  5. #5
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    sorry i didn't see your replies before I replied.

  6. #6
    nick243 is offline Competent Performer
    Windows 7 64bit Access 2002
    Join Date
    May 2016
    Posts
    185
    Yes Joe I believe you have answered my question.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-26-2016, 06:42 AM
  2. Exporting & Importing Data
    By Pure Salt in forum Import/Export Data
    Replies: 4
    Last Post: 12-02-2014, 05:23 PM
  3. Exporting/Importing to Outlook
    By IdleJack in forum Import/Export Data
    Replies: 2
    Last Post: 08-27-2011, 06:13 AM
  4. Need Help With Importing/Exporting
    By shoover in forum Programming
    Replies: 0
    Last Post: 04-18-2011, 01:33 PM
  5. Best Way of Exporting/Importing
    By shoover in forum Programming
    Replies: 0
    Last Post: 04-04-2011, 08:33 AM

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