Cannot edit data, please help.

[Lee Taylor-Vaughan]

Hello,

I have SQL server as back end, ODBC connection, I have full admin-access
rights with SQL server. I am able to edit records if i open table in SQL

i have created front end with a few forms on it. I am not able to edit any
data on these forms.

also, i just noticed that i cannot edit any data anywhere from within
access. How can I edit my data in my forms, or even tables for that matter.
(message = "Recordset is not updateable", but it is when i am in SQL!)
please help... i am really stuck on this one

TIA

Lee

 

[Andy Williams]

Lee

Do you have Primary Keys specified on your Data Tables?

If not you won't be able to update SQL Tables using Access.

HTH

Andy W

 

[Jeff Boyce]

In addition to Andy's observation about primary keys in SQL Server, if you
have linked to the SQL Server tables from Access via SQL Views, you would
also need to specify the primary key(s) for the View to be updateable (more
recent versions of SQL Server).