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'd be expecting to put in the workspace is:
Server Link Table "create unique index ""MI_ID"" on tblMILINK(RecordID)"
Using "DSN=MS Access; DBQ=C:\MSOFFICE\ACCESS\DB1.mdb" Into test File
"C:\tmp\test"
This should just update the index, no data will be returned, no table
opened, and no file created (hopefully).
Notice the two sets of double quotes around the MI_ID to pass a single
set. If you don't know the connection string (after 'using'), you'll
probably be able to find it in the TAB file that you use to access the
table.
I hope that helps.
Andrew
On Thu, 2 Sep 2004 11:41:17 +0100, Julian Balson
<[EMAIL PROTECTED]> wrote:
> 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 workspace.
> Julian.
> This Electronic Transmission is intended only for the attention of the
> addressee. It may contain privileged and confidential information. If
> you are not the person for whom it is intended, you must not copy,
> distribute or take any action in reliance on it. If you have received
> this electronic transmission in error please notify us immediately by
> telephone, delete the transmission and destroy any hard copies.
> Nicholas Pearson Associates has used all reasonable efforts to ensure
> that this message and any attachments are free from viruses.
> Nicholas Pearson Associates
> Environmental Planners - Landscape Architects - Ecologists
> 30 Brock Street, BathBA1 2LN
> Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387
> www.npaconsult.co.uk
>
--
----------------------
Andrew Harfoot
Geodata Institute
University of Southampton
tel: +44 (0) 23 80592719
fax: +44 (0) 23 80592849
[EMAIL PROTECTED]
This Electronic Transmission is intended only for the attention of the addressee. It
may contain privileged and confidential information. If you are not the person for
whom it is intended, you must not copy, distribute or take any action in reliance on
it. If you have received this electronic transmission in error please notify us
immediately by telephone, delete the transmission and destroy any hard copies.
Nicholas Pearson Associates has used all reasonable efforts to ensure that this
message and any attachments are free from viruses.
Nicholas Pearson Associates
Environmental Planners - Landscape Architects - Ecologists
30 Brock Street, BathBA1 2LN
Tel: +44 (0) 1225 445548 Fax: +44 (0) 1225 312387
www.npaconsult.co.uk
