If you open the Access table using ODBC instead of DAO you will be able to edit the table from both MapInfo and Access at the same time. ODBC even gives you some troubleshooting for handling conflicts, when a record has been altered from both MapInfo and Access.
Peter Horsb�ll M�ller GIS Developer Geographical Information & IT COWI A/S Odensevej 95 DK-5260 Odense S. Denmark Tel +45 6311 4900 Direct +45 6311 4908 Mob +45 5156 1045 Fax +45 6311 4949 E-mail [EMAIL PROTECTED] http://www.cowi.dk/gis Sidste frist for tilmelding til MapInfo Konferencen er den 25. august 2004. Tilmelding samt yderligere information kan ses p�: http://www.cowi.dk/GIS -----Original Message----- From: David Baker [mailto:[EMAIL PROTECTED] Sent: Monday, August 23, 2004 9:19 AM To: [EMAIL PROTECTED] Subject: MI-L Open Access tables in MI but still allow editing in Access? I use the following MapBasic code: Register Table "C:\Program Files\MVMMap\Data\VESSELS.MDB" Type "Access" Table "Vessels" Into "Vessels" Open Table "Vessels" Which opens an Access database in MapInfo. While it is open in MapInfo, I am able to also open the database in Microsoft Access & view it, but I am unable to edit any of the fields using Access. (It says "This recordset is not updatable" and I can see a .lck file in the same folder as my .mdb file) Is this normal? If so, is there any way around it? I can't see any more parameters that I can change in the Register Table of Open Table commands. It was my hope that I could edit some fields in Access at the same time as MapInfo was using the database, but this looks like it might not be possible...which will mean back to the drawing board! :-) Dave --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13041 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 13042
