Question:
I am trying to connect to an Informix database via ODBC from Microsoft Access 2000. When I import a table from the Informix database, I see all the data. But why can’t I open the datasheet to view the records when I link the table?
Answer:
Check to see that you have at least one unique primary key index on the table. Access requires this but Informix does not.