SQL Server tables

  • Thread starter Thread starter mike w.
  • Start date Start date
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.
 
Mike,

I work with Access 2000 with SQL Server links and have
some working knowledge with SQL Server. You will need to
get/have access to the SQL Server where the SQL tables
reside. You can not change the SQL table properties
through the ODBC links. You must go to the SQL Server and
change the tables properties (insuring that the change
will or will not affect other tables, foreign key
relationships, if any). Then delete the current ODBC
links, because they retain the properties of the SQL
table before the change, and relink the tables.
 
Back
Top