Tables - ODBC

[Adrienne]

I tried to link 4 different ODBC tables with a Make Table
Query. The query bombed out with an error message ODBC
called failed ORA 01013. (Keep in mind each table has
thousands of records and houses data as far back as 1992,
I have to go to the criteria and ask for 2003 data) I'm
only interested in pulling certain fields from each of the
tables to come up with one Make Table Query. Should I run
4 different Make Table Queries and then run an Append
Query based on the primary key? Better yet, can you
instruct me how to do this????


Urgent Help Needed!!!

 

[Tim Ferguson]

Should I run
4 different Make Table Queries and then run an Append
Query based on the primary key? Better yet, can you
instruct me how to do this????

Without a lot more information it's hard to say. Why do you want to create
a new table anyway?-- the advantage of linking is that you are always
interacting with the most up to date information in the original database.
If you only want a few fields, then you should be able to create a query
that only presents those fields: it would be most efficient if you could
get the admin to set up a query/ view on the database server itself.

As for linking the tables, then it's really a question for the database
design, and what the tables represent and how they are related...

HTH a bit


Tim F