Linked tables differ from original tables 1

[mbowler9]

I am linking many Access 97 tables from an Informix database. One table isn't (or doesn't appear to be) the same as the original. Can anyone tell me why or how this could happen, or if it is even possible? As you can see below, my table simply repeats the first record and ignores the second. There can be multiple method, frequency and level for sys_name and dns. sys_name and dns are set as key. Thanks in advance.

Original Table

sys_name dns method frequency level
argon sample.com Ignite weekly primary os
argon sample.com Veritas daily primary sys


Linked Table

sys_name dns method frequency level
argon sample.com Ignite weekly primary os
argon sample.com Ignite weekly primary os

 

[willir]

mbowler9

I assume you are you are using ODBC to link to the tables.

I am puzzled about your (primary?) key. "sys_name and dns name are key", yet "argon + sample.com" is displayed twice.

Since you have more than one record displayed for "argon + sample.com", it is possible that more may be buried further down the table.

Run a query and sort it, perhaps by sys_name, dns, method. This way, if any of the other records are buried, you will be able to see them in the sorted listing.

By the way, nice to see Informix being used. I have not seen this database application in years.

Richard

 

[mbowler9]

Thanks willir. Yes I am using ODBC. There must have been something buried down lower as you said, because sorting all the fields ascending worked perfect.

Informix seems to be doing well for us...went to an IBM Autobahn and it seems they have big plans for it.