Bring in the Access as an ODBC table, then the Spatial as a MapInfo table. Do a SQL join between the two tables. Then save that as a new table. Next time open the saved table. This will keep the join. Be warned unless you have a unique key in the Access table you will not get read write. You can also try the live ODBC with MI5 and up. Yours Anton -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Gypsy Bhalla Sent: Tuesday, 12. October 1999 02:30 To: [EMAIL PROTECTED] Subject: MI ODBC Hi Mapinfo users, I am in the middle of trying to set up an ODBC link to an Access table (have got that worked out using the mapinfo manual), however now what I have to do is link this table to another existing Mapinfo table (with digitised vectors in it) and to then retain these links when the system is brought up the next time - mirroring any changes within the access database table. Has anyone had experience with this and be willing to share the process of setting it up? TIA Gypsy Gypsy Bhalla GIS & Remote Sensing Project Manager AGRECON, 18A50 E-mail: [EMAIL PROTECTED] University of Canberra Phone: +61 2 6201 5251 170 Haydon Drive Fax: +61 2 6201 5353 Belconnen, ACT, 2616 ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED] ---------------------------------------------------------------------- To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]
