I have a MS Access 97 SR-2 database with this table:
CREATE TABLE table1 (tab1_id COUNTER CONSTRAINT pk_table2 PRIMARY KEY, descr TEXT);
And this view/ query (named "view1"):
SELECT * FROM table1;
I wish to open a Live Access DBMS connection to view1 in MapInfo, but when I do that, I get this error message: "Cannot Open Table for Live Access. A single key column is required on the table. Unable to open view1."
I did find a few articles that shed a little light on the subject. My conclusion by reading this was that my view/ query needed a unique index in order to be accepted by MapInfo, but I'm not sure if this is possible and have no idea how to do it.
Can somebody help me solving this problem?
Here are the articles I found about the problem, you might find them useful.
(mapinfo Professional 5.5 User's Guide p. 403 "Every table must have a single unique key column")