Hi, reading my own thread I can see that it can be misunderstood. You shouldn't rename the column in the base table, but just in the view with an alias:
Select ID As MI_PRINX, NAME, ... Also make sure that the primary key column contains integers, not strings. 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 -----Original Message----- From: Tony Baylis [mailto:[EMAIL PROTECTED] Sent: Monday, November 21, 2005 1:03 AM To: Peter Horsbøll Møller Cc: [EMAIL PROTECTED]; MATT KITOSKI; [email protected] Subject: Re: [MI-L] Cannot Open Table For Live Access Morning all, Hope you don't mind if I jump into this thread but I too am having very similar issues with opening live links from Access queries/views. I have followed all suggestions made previously, including changing the name of my primary key integer column to MI_PRINX but I still get the 'require primary key column error'. It won't even open the original table containing the MI_PRINX column for the same reason. I have done this a number of times before without too much trouble and can't figure out what's going on. At this stage I'm more than a little frustrated for a Monday morning so if anyone has any ideas it would be greatly appreciated. Tony -- Tony Baylis Spatial Information Specialist Resource and Exploration Mapping Suite 8, 290 Boundary St Spring Hill QLD 4000 Ph 3832 1600 Fax 3832 1603 Mob 0419 759 131 Email [EMAIL PROTECTED] www resexmap.com.au Peter Horsbøll Møller wrote: > 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 > -- Tony Baylis Spatial Information Specialist Resource and Exploration Mapping Suite 8, 290 Boundary St Spring Hill QLD 4000 Ph 3832 1600 Fax 3832 1603 Mob 0419 759 131 Email [EMAIL PROTECTED] www resexmap.com.au _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
