Nope the methode with the Register table is the "ADO"-way of connecting to a
Access-database.
I guess your are now using this - or at least you should be:
Server COCIConnectionID() Link Table
"Select * From VESSELS"
Toolkit "ODBC"
Into "VESSELS"
File "C:\Program Files\MVMMap\Data\VESSELS.TAB"
Where COCIConnectionID() returns the number of the connecting in MapInfo. You can also
in some specify the connect string, so have a look at "Server Link Table" in the
MapBasic Documentation
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
Har du husket MapInfo Konferencen d. 8 og 9. september 2004.
Tilmelding samt yderligere information kan ses p�: http://www.cowi.dk/GIS
-----Original Message-----
From: David Baker [mailto:[EMAIL PROTECTED]
Sent: Monday, September 06, 2004 12:04 PM
To: [EMAIL PROTECTED]
Subject: RE: MI-L Open Access tables in MI but still allow editing in Access?
On 6 Sep 2004 at 8:37, Peter Horsb�ll M�ller <[EMAIL PROTECTED]> wrote:
> Hi David
>
> This is the magic sentence:
>
> Server Refresh MYTABLE
>
> But this is ony nessessary fi you are using the linked table. If you
> have connected to the database using "Live" the changes have been sent
> to the database when you save the table.
Still on my learning curve here... :-)
By "Live", do you mean using the
Register Table "C:\Program Files\MVMMap\Data\VESSELS.MDB"
Type "Access" Table "Vessels"
Into "Vessels"
Open Table "Vessels"
method? I can't use that method as it locks Access from accessing the table for write
while it's open in MapInfo. Or is there a 3rd method besides linking method &
registering method?
I tried the
Server Refresh MYTABLE
method after the line
Update Vessels Set Name = TempName where RowID = currentRow
& initially I got an error "Cannot perform this operation on table Vessels" which was
a bit
confusing. I put the command after my line
Commit Table Vessels Interactive
and now I don't get an error, but the new information isn't saved. Most confusing! :-)
So, I'm still poking around. Worst case scenario is that I do all my database writing
in
MapInfo instead of some of it in Access/VB & some in MapInfo.
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: 13224
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Message number: 13227
