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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using "like" from an external link 1
Pass through / ODBC Data Source 6
Update ODBC Link Table 2
update query ODBC--call failed 3
Using ODBC Connection Query Error: Non-Updatable Query 4
Make Table Query to external ODBC SQL Server database 17
Pass-Through Query / Multiple ODBC Connections 1
querydef: using external odbc 2

Back
Top