Thanks Andrew that's basically done the trick (list see below).
-Original Message-
From: Andrew Harfoot [mailto:[EMAIL PROTECTED]
Sent: 03 September 2004 11:36
To: Julian Balson
Subject: Re: MI-L Create unique index for Access tables in workspace?
Hi Julian,
The command syntax I
al Message-
From: Julian Balson [mailto:[EMAIL PROTECTED]
Sent: September 02, 2004 06:41
To: [EMAIL PROTECTED]
Subject: RE: MI-L Create unique index for Access tables in workspace?
Thanks for your help Mike and Andrew.
I have had a good try at altering the workspace to load up the linked
tab
Thanks for your help Mike and Andrew.
I have had a good try at altering the workspace to load up the linked
table (as suggested) but could do with some more help, as I do not seem
to be getting anywhere.
I want to open an Access table as a live table in MapInfo using code
contained in a work
e from the mapbasic window on the end of the text of
the workspace.
-Original Message-
From: Julian Balson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 01, 2004 6:54 AM
To: [EMAIL PROTECTED]
Subject: MI-L Create unique index for Access tables in workspace?
Dear list,
We need t
Dear list,
We need to create a unique index on Access tables using a statement in
the workspace. We currently have to manually run the SQL statement:
"create unique index "MI_ID" on tblMILINK(RecordID)" in the MapInfo DBMS
SQL runner every time a table (e.g. tblMILINK) is updated in Access, to
a