Copy query between two separate databases using external ODBC link

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two databases linked by ODBC to two separate file libraries on an
AS-400. The file structure in both libraries is exactly the same, but the
data is different. I only want to maintain one database, so I usually update
database 1 and then copy any of the queries, reports, etc. over to the second
database. The problem is that when I copy a query, the table links point to
the original library. Is there any way to copy a database or query to
another database and have it automatically update the machine source, as long
as the field names within the machine source are the same?
 
In query design view click on menu VIEW - SQL view and copy. Open a new
query in the other database and go to the SQL view and paste.
 
Back
Top