Link to home
Create AccountLog in
Avatar of NigelRocks
NigelRocks

asked on

Accessd Query not Working

Experts,

I'm attempting to do a simple correlated update over an Access 2007 table like this:

UPDATE Notes SET Notes.Note_Category_Descripton = DLOOKUP("Note_Categories. Note_Category_Descripton ", "Note_Categories", " Note_Category_ID = " & Notes_Category);


However, I'm told that the field "Note_Category_Description" cannot be updated because the field is "not updateable".  This is the first time I've ever seen anything like this.

Ideas?
ASKER CERTIFIED SOLUTION
Avatar of saji1976
saji1976

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
SOLUTION
Avatar of Hamed Nasr
Hamed Nasr
Flag of Oman image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account