Malcolm I have had this problem and found it was caused when I made changes to the MapInfo table that was linked to my Access database and then did not update the changes to the Access table when I closed MapInfo. If you make changes to a MapInfo table that is linked to an Access table, when you eventually close the MapInfo table you should get a dialogue box giving you the option of copying those changes to the Access table. When I did this the problem you describe went away! I hope this is some help.
The matter of linking to Access and all the potential problems, as well as the pros and cons of linking with ODBC or just opening an Access table directly from MapInfo, seems to be very poorly documented. The MS help on ODBC is, in my opinion, a dog's breakfast of geek-speak with the occasional English word thrown in. For instance if one is not on a network is there any difference between "File Data Source" and "Machine Data Source" when setting up an ODBC link? If anybody knows an information source regarding ODBC and MapInfo and the best way of using Access tables, I would love to hear of it. John ------------------------ John Elliot Anzeco Pty. Limited mineral exploration consulting services Bathurst, NSW 2795, Australia Email: [EMAIL PROTECTED] ----- Original Message ----- From: "Norman, Malcolm" <[EMAIL PROTECTED]> To: "'Mapinfo-L (E-mail)" <[EMAIL PROTECTED]> Sent: Saturday, November 03, 2001 2:43 AM Subject: MI-L > Hello Lister's > > can some one help me with a small problem: > > I have an access database linked to mapinfo. When I open one of the tables > in mapinfo I get a message stating that some one else is editing the table > and it opens in read only. I am the only person accessing the data and the > pc did crash so I assume that the lock is still in place. I have looked at > the table files in explorer and found one with a '*.lin' extension, is this > the lock file and if so how do I remove it? > > Regards > Malcolm Norman _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
