Database Connectivity

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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

Recent Articles: