ODBC Table

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I converted an ODBC Table to a make table query.
and everything worked fine the table had 5398 records.
The next thing that I was ask to do was to include another
ODBC table into the already designed make table query the
two tables have pretty much the same fields accept for a
few new ones. When I set up the select query (to combine
the make table query with the new ODBC table)my total
number of records decreased to 4818??? Can someone explain
why this happened? Keep in mind the ODBC Tables are in
Oracle 8 and I have to log into the tables and extract by
critieria what I want to see in Access. Both ODBC tables
after their extraction are correct when I perform a make
table query separately but when I pull but tables together
in a Select query something happens to my records.
Help!!!! What should I do to keep the record count the
same???
 
Allison

An "ODBC" table could mean you are linked to a table using an ODBC driver,
or it might mean that you've created an Access table (?make table) that is
based on data that originally came from a table linked by an ODBC driver.
Which do you mean?

When you say you designed a make table query, do you mean that you created a
new table in Access, or in Oracle?

If you use a make table query twice, you are totally destroying the first
copy, and replacing it with what is available for the query the second time
around.

If you need to regularly replace the data in a local (i.e., Access) table,
based on a linked source (e.g., Oracle), you could use an append query
(after first removing/deleting the rows). This preserves the structure. It
also allows you to append NEW records, provided you've indexed your local
table to prevent duplicates based on ... (whatever shouldn't be duplicated).

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top