Not updateable query

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

Guest

I am trying to update a field from a field on a temporary table, but I am
getting an "Operation must use an updateable query" error. I am not sure
why, as similar queries have worked before, and it doesn't seem to violate
any of the conditions in the Help file. I am working in Access 2002 with a
database file in Access 2000 format. The SQL is below. All fields are text
fields. "Key" is the primary key field for each table. Neither "Field2" has
any relationships to any other fields in the database. There are no other
users of the database. Am I missing something?

UPDATE tblOne INNER JOIN tblTemp ON tblOne.Key = tblTemp.Key SET
tblOne.Field2 = [tblTemp].[Field2];

Thanks,
John
 
I am trying to update a field from a field on a temporary table, but I am
getting an "Operation must use an updateable query" error. I am not sure
why, as similar queries have worked before, and it doesn't seem to violate
any of the conditions in the Help file. I am working in Access 2002 with a
database file in Access 2000 format. The SQL is below. All fields are text
fields. "Key" is the primary key field for each table. Neither "Field2" has
any relationships to any other fields in the database. There are no other
users of the database. Am I missing something?

UPDATE tblOne INNER JOIN tblTemp ON tblOne.Key = tblTemp.Key SET
tblOne.Field2 = [tblTemp].[Field2];
Click to expand...

Hrm. That *ought* to work. Doublecheck in table design that the field
Key in fact is the sole Primary Key field, or otherwise has a unique
Index.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Thanks, I thought it *ought* to work - I've done the same thing many times.
I'm not sure what happened, but I re-created the same query from scratch and
it worked this time.

John

John Vinson said:
I am trying to update a field from a field on a temporary table, but I am
getting an "Operation must use an updateable query" error. I am not sure
why, as similar queries have worked before, and it doesn't seem to violate
any of the conditions in the Help file. I am working in Access 2002 with a
database file in Access 2000 format. The SQL is below. All fields are text
fields. "Key" is the primary key field for each table. Neither "Field2" has
any relationships to any other fields in the database. There are no other
users of the database. Am I missing something?

UPDATE tblOne INNER JOIN tblTemp ON tblOne.Key = tblTemp.Key SET
tblOne.Field2 = [tblTemp].[Field2];
Click to expand...

Hrm. That *ought* to work. Doublecheck in table design that the field
Key in fact is the sole Primary Key field, or otherwise has a unique
Index.


John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
Click to expand...
 
Back
Top