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
