access/sql server

  • Thread starter Thread starter ron demus
  • Start date Start date
R

ron demus

when I try to add or delete data in a record I get an
error message "this recordset is not updatable"
 
when I try to add or delete data in a record I get an
error message "this recordset is not updatable"
Click to expand...

That's because the recordset is not updateable. This can occur for a
variety of reasons; if the table is in SQL/Server, it may not have a
Primary Key or Access may not have been told what the Primary Key is.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference in size of actual access database and its backup 0
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Invalid Column Name Sql-Error :Executing a stored procedure 1
Re-Seed in SQL Server 8
replacing a link to a SQL Server table with VBA 1
SQL not importing records from ACCDB 2
Pass Field Name Using Variable to SQL string 2
not in criteria fails 2

Back
Top