cannot edit data... Please help

  • Thread starter Thread starter Lee Taylor-Vaughan
  • Start date Start date
L

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
 
Lee Taylor-Vaughan said:
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
Click to expand...

Do the tables have Primary Keys defined on the server? If not any link will be
read only unless you define which columns to use for a local unique index when
the link is created.
 
how do i create them... i am new to SQL!
Rick Brandt said:
Do the tables have Primary Keys defined on the server? If not any link will be
read only unless you define which columns to use for a local unique index when
the link is created.
Click to expand...
 
Lee Taylor-Vaughan said:
how do i create them... i am new to SQL!
Click to expand...

Do you have the SQL admin tools installed, like Enterprise Manager? That is
what I would use.
 
Back
Top