Thanks Peter, this was well explained. May i know if i have 3 tables to access do i have to create 3 ODBC connection? Email Required, but never shown. By using our site, you acknowledge that you have read and understand our Cookie Policy , Privacy Policy , and our Terms of Service. If you want to create a linked table, have a look at Server Link Table statement. I would like to create a tools that will open and link my tables in access and update it time to time when every time i change something on my mapinfo table.

Uploader: Fenrizshura
Date Added: 17 May 2012
File Size: 6.23 Mb
Operating Systems: Windows NT/2000/XP/2003/2003/7/8/10 MacOS 10/X
Downloads: 72865
Price: Free* [*Free Regsitration Required]

I could make it manually and able to have a link between my tables to work on. Home Questions Tags Users Unanswered.

Sign up or log in Sign up using Google. MapBasic has a number of functions and statements that can be used to work with spatial databases: It’s now time to start using this connection. When working with any database from MapInfo Pro thru MapBasic you need to first establish a connection to the database.

  ACER ASPIRE 4736 CRYSTAL EYE CAMERA DRIVER DOWNLOAD

I would like to create a tools that will open and link my tables in access and update it time to time when every time i change something on my mapinfo table. By using our site, you acknowledge that you have read and understand our Odbd PolicyPrivacy Policyand our Terms of Service. Sign up using Facebook.

Odbv would recommend always running a Refresh statement after committing changes. Post Your Answer Discard By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies.

MapInfo Pro and ODBC Data sources

But i don’t know how should i start coding and update my table in access using mapbasic. Email Required, oebc never shown. If you want to create a linked table, have a look at Server Link Table statement. But i don’t know if i have to code it in mapbasic to call my table in access and able to have a link between tables and have it update it. Now the integer variable nConnection holds the ID of the connection that you just opened to your database.

  LAN8720A LINUX DRIVER

To Refresh a table you use the Server Refresh statement. Sign up using Email and Password. Post as a guest Name. I already created an ODBC data source manually.

May i know if i have 3 tables to access do i have to create 3 ODBC connection? Once you got your tables open, you save the changes back to the database via the Commit Table Statement.

MapInfo Pro and ODBC Data sources

If you want to create a live table use the Register Table statement. This require a data soruce which I can understand you already have.

Server Link Table Statement: MapBasic has a number of functions and statements that can be used to work with spatial databases:. Thanks Peter, this was well explained. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy ampinfo and cookie policyand that your continued use of the website is subject to these policies.