I think you have misunderstood something here. The only databases that MapInfo can store "true" spatial objects in are: - Oracle 8i, 9i with either the spatial extension are the locator build-in - SQL Server with either MapInfo SpatialWare or MapInfo Pro for SQL Server - Informix with MapInfo SpatialWare - (DB2 with MapInfo SpatialWare)
But you can store points in Access (and any other ODBC compliant database) The point is stored as coordinates in two columns and when opened MapInfo automatically creates points for these coordinates. This is only the case when using ODBC to connect to the database. If you are using DAO (thru File > Open) you'll have to create the points yourself and MapInfo will not update the coordinates in the database automatically. Peter Horsb�ll M�ller GIS Developer COWI A/S - Geografisk Information & IT Rug�rdsvej 55 DK 5000 Odense C Tel +45 6313 5013 Direct +45 6313 5008 Mobil +45 2270 4308 Fax +45 6313 5090 Kampsax blev i juni 2002 overtaget af COWI. I forbindelse med den igangv�rende integrationsprocess udskiftes vores Kampsax e-mail adresser med COWI e-mail adresser.Hjemmesideadresser forbliver u�ndrede > -----Original Message----- > From: James Barnes [mailto:[EMAIL PROTECTED] > Sent: Monday, March 17, 2003 7:33 PM > To: [EMAIL PROTECTED] > Subject: MI-L MS Access Tables and spatial objects > > > I am using MS Access2000 as my data tables for Mapinfo V7. I > have made each > relevant table mappable and ensured each table has an index > field. The data > in the table is for water/sewer reticulation > > I was expecting that by doing this Mapinfo would store the > spatial object > within the Access table and that there would not be a need to > distribute any > Mapinfo tab files. Users once they opened the Access table > would have a > spatial representation of the data from the table ie the > pipelines and point > features. > > Have I got it correct in that Access holds the spatial object > and that I > only need to distribute the database to system users? > > Thank you for any advice > > James Barnes. > > > > > > > _________________________________________________________________ > Help STOP SPAM with the new MSN 8 and get 2 months FREE* > http://join.msn.com/?page=features/junkmail > > > --------------------------------------------------------------------- > List hosting provided by Directions Magazine | > www.directionsmag.com | To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > Message number: 5977 > --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 5984
