Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Melwal
Starting Member
1 Post |
 Posted - 2006-06-02 : 14:02:36
|
| Hi All,I am trying to execute this query in Access 2003 and it keeps giving me Operation must use a updatable query error. I tried this in SQL and the query works. Is there any other way to get this done in AccessUPDATE table1 SET rows_affected_no = (select count(*) from table2); |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-06-06 : 11:47:08
|
| Do it in 2 stages?Assign "select count(*) from table2" to a variable(x).then "UPDATE table1 SET rows_affected_no = variable(x)" |
 |
|
|
|
|
|
Update qUERY GENERATING ERROR