Thanks Leith, Your suggestion of using the ODBC connection has solved my problem of updating the map w/o the use of 'create points', making the whole process a lot less painful; thanks for that! Also a big thanks to all others who offered suggestions on linking directly to forms; it seems as if the two options are either setting the form as the default display when opened under Tools - Startup - Display Form/Page (Leith , Eric), or dragging and dropping the form to the desktop and then hotlinking to the shortcut (Dominic). Although neither are ideal for databases w/ many forms; both suffice and do an adequate job of getting directly to the form. Ian suggested that in lieu of forms, a MS 'data access page' could be used which would essentially do the same job and is easier to link. I imagine this is a better way, but as a new Access user, I will have to muddle my way through it...
Cheers, Scott -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, March 29, 2004 4:25 PM To: Lewis,Scott [Dartmouth] Cc: [EMAIL PROTECTED] Subject: Re: MI-L More MS Access questions.... 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: 11184
