I have done this before, but for me it was a real pain.
I used the DBMS Catalog Tool that is included with MapInfo to create a
catalog in my database.
Quote form the Tool, "This program allows a DBA to create a MapInfo Map
Catalog table in a remote database. The MapInfo Map Catalog is needed for
downloading coordinate information to MapInfo from the remote database."
It reads and writes the x and y coords from MapInfo to the db.
The application I wrote takes information entered from a customer service
rep in Access and pulls it into MapInfo thru a ODBC connection, then
Geocodes the information based on a street address and then writes the
points x and y coords back to the db. When you refresh the data the points
are then automatically redisplayed using their coords.
Leith C. Britt
Town of Cary
Technology Services
Database Analyst
phone: 919-469-4383
fax: 919-462-3891
web: townofcary.org
"Lewis,Scott
[Dartmouth]"
<[EMAIL PROTECTED] To
C.CA> <[EMAIL PROTECTED]>
cc
03/29/2004 12:06
PM Subject
MI-L More MS Access questions....
Hi all,
MS Access seems quite good in that any changes made in either Access or
MapInfo will be visible in the other immediately . My problem is that
if I add geographic points in Access I will be able to see them in the
Browser window of MI, but in order to see the points on the map I have
to use 'Create points..." once again. Is there a way that it will
automatically update these points onto the map without going through
this step. Also when I remove a point location from the list it appears
gone from the list; but the point itself remains on the map. Any ideas
of how to avoid either of these problems? It can be frustrating as right
now it means I must create a new .tab file with any Access updates!
Thanks,
Scott
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 11165
