Hi, list-users. Can you help me with this question: Is it possible to establish a Live Access ODBC-connection to a MS Access query?
This is my table/ relation (named "table1"): CREATE TABLE table1 (tabid COUNTER CONSTRAINT PrimaryKey PRIMARY KEY, description TEXT); This is my query/ view (named "view1"): SELECT tabid AS MI_PRINX, description FROM table1; When trying to set up a connection I get the error message "Cannot Open Table for Live Access. A single key column is required on the table. Unable to open view1." Other threads that cover this topic: http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/12dcce0bd0474519852564370063f 39d/0a80290a4268cc0d85256bc8005a3299?OpenDocument http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/12dcce0bd0474519852564370063f 39d/b41d8f5184f0668285256ab7007de32f?OpenDocument http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/12dcce0bd0474519852564370063f 39d/dfb645485d0664d2852569dd0060cbca?OpenDocument http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/12dcce0bd0474519852564370063f 39d/eac62a3a4d7cd7a7852566aa005b6073?OpenDocument http://testdrive.mapinfo.com/tdc/mapinfo-l.nsf/12dcce0bd0474519852564370063f 39d/f2908113db9ad06285256c1000185d23?OpenDocument http://testdrive.mapinfo.com/techsupp/miprod.nsf/d9c4e33650769aec852566bf006 03719/df1d5d1eeeffe351ca256873001f417f?OpenDocument http://www.mapinfo.com/registration/discussions/thread.jsp?forum=6&thread=10 35&message=3338&q=live+access --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 2524
