Duplicate Records in Access 2000 linked to SQL 2000

  • Thread starter Thread starter bndavid
  • Start date Start date
B

bndavid

I have 8 tables in my SQL 2000 that were imported from an
Oracle database, and are now linked through ODBC
connection into Access 2000. All 7 linked tables from my
SQL are correctly displayed into Access except for 1
table. That problem table shows multiple duplication of
records in Access, but shows unique records in my SQL
server.

Any suggestions to correct this problem is appreciated.

Thanks.
Ben
 
I guess we all know that this should not happen. Maybe you
are not looking at what you think you are looking at.

When Access links tables, it maintains a local name and a
foreign name for the object. So while the name in the
table window might say tblCustomer, the linked object
might be vwAllCustomers in sql2000.

Go to tools options view, and select "hidden objects"
and "system objects"

The open table MSysObjects and scan down the "Name" column
until you find your table. Then look at
the "foreignName", "Database" and "connect" columns to see
exactly what you are seeing.
 
Back
Top