M
mike w.
Hello,
I need to add Identity field to an existing SQL Server
table.
Then I need to to change this field to be the Primary key
Then I need to remove another exisitng field
Then I need to to add a Clustered Index to the table
All through ADO (or ADOX?).
I'm an Access guy, and I only have Access 97, and I just
got thrown a SQL server DB
and I won't have any SQL Server software on my PC for
awhile.
So I HAVE to do some this via code only.
I've linked the SQL Server tables in to my Access97 DB
through an ODBC but I can't make changes to linked tables.
help
mike w.
I need to add Identity field to an existing SQL Server
table.
Then I need to to change this field to be the Primary key
Then I need to remove another exisitng field
Then I need to to add a Clustered Index to the table
All through ADO (or ADOX?).
I'm an Access guy, and I only have Access 97, and I just
got thrown a SQL server DB
and I won't have any SQL Server software on my PC for
awhile.
So I HAVE to do some this via code only.
I've linked the SQL Server tables in to my Access97 DB
through an ODBC but I can't make changes to linked tables.
help
mike w.