Operation must use an updateable query.

the annoyance of my very existence...

I seem to have this problem with both C-ASP and ASP.NET..could someone with a brain (unlike me) shed some sort of light on this subject please?

it only ever happens when i work with an access db not MySQL (takes cover as i can see the SQL server guys grab pencils and items to thow @dotnet.itags.org. me)

Thank you...

PWPaust
www.abyss.wsHi,

see this thread in Access forum
view post 154273
This can occur if you are attempting to perform an update against a query with a join.

if you use a primary key on both side of the join, it wont happen.

if you cant use a primary key, then you can try removing the join and replace it with a subquery.

i.e

Update tblUpdateThis set field1 = "something" where field2 in (select field2 from tblJoinedTable where field2=something)
Is your Access database file read-only? That would cause the problen you're seeing...