One important thing to remember is that MapInfo needs some help to find a primary column in a view. Rename the primary column to MI_PRINX and I think you'lll be ready to rock and roll ;-)
Peter Horsbøll Møller GIS Developer, MTM Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis COWI har fået ny hjemmeside. Ydelserne GIS og IT, kort, kortlægning, 3D visualisering og arealforvaltning ligger under SAMFUND. Se mere her : www.cowi.dk COWI has changed its homepage. Our services within cadastre and landadministration, geodataproducts, mapping and GIS can be seen under SOCIETY. See our services here: www.cowi.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Thursday, November 17, 2005 11:00 PM To: MATT KITOSKI Cc: [email protected] Subject: Re: [MI-L] Cannot Open Table For Live Access Matt, Are you using an ODBC link to the access table? Generally mapinfo needs a autonumber field or an integer field to act as a primary index. Is it a view (in which case i would have thought it would have found the unique key field), or is it a table that the primary index is no longer the primary index, but merely a integer field? Posibly need more info. r > Hello, > > I am trying to bring in a query table from Access into Mapinfo > and I am receiving the error message, "Cannot open table for live > access. A single numeric key column is required on the table. Unable > to open table Query1. > > This would lead me to believe that the formatting is incorrect > in one of the columns or that it is missing a primary key field. But, > this table was queried off of a table that was able to be imported > into Mapinfo from the database. hmmmmmm, any ideas??? > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l > _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
