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
allow us to open the table live in MapInfo. Is there a way of including
a similar instruction in the workspace so that MapInfo carries out this
procedure automatically every time the workspace is opened?
Julian Balson.
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
