using ODBC to link to a SQL Table

[billb]

I am using access 2003 to link to sql tables using odbc. I create the tables
in access then export them to sql, then link to them using ODBC. The trouble
is that I can not perform any functions to the linked tables. I can not add
any new records, or modify the linked tables in any way, such as adding new
fields. I can not delete the tables, and am stuck with the records that were
added before I exported the tables to sql. Please help. I have been using
access sence 95 but have always used acces as a back end. We now have SQL
and I would like to use it as a back end.
I can add the existing tables to SQL but that is as far as i can get,
after linking to the tables using ODB I am stuck with the records that were
in the tables when I exported them to SQL. What am I doing wrong.

Desperate in denver Bill

 

[Douglas J. Steele]

If your tables in SQL Server don't have primary keys defined, you won't be
able to add new records, nor modify existing records.

If by "modify the linked tables" you mean add new fields, you need to do
that in SQL Server and then relink the tables.