Recordset is not updateable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

This is the first time i try to edit a record in datasheet view that i get
this error message.I can not make changes to this query.What could cause this
to happen?
Thanks
 
Hi,

There are many cases: you use an aggregate (SUM, COUNT, ... ); you use
DISTINCT, you use UNION, you use an explicit join in the WHERE clause rather
than an implicit join in the FROM clause, ... What is your SQL statement?


Hoping it may help,
Vanderghast, Access MVP
 
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

Recordset not updateable 3
Recordset update query 2
Editing data in datasheet view from a query joining other tables 2
Access 2007 "This Recordset is not Updateable" 3
Mysterious Recordset Changes 1
Recordset automatically updates 2
Recordset not updateable 2
Why can I not rearrange the columns in my crosstab query? 1

Back
Top