How to make a query updatable in Access

[usr123]

I have got a very simple sql query in access, and i m trying to update the record in the table. It is coming up with the error that use updatable query.
What do i need to do to make my query updatable?

[TheSmileyCoder]

Query's are per default updateable. What makes Access not able to update records, is if you use joins incorrectly.

Start by posting your full SQL, and we can look at it.

[usr123]

This the final sql query.

"Update dbo_fin_ldg set ldg_Year = 2010, Month_Name = 'Feb',ldg_Month = 02,Product = '',Category = 'Gear',Customer = '',Actual_Volume = 12,Budget_Volume = 1245 Where dbo_fin_ldg.ID = 2488;"

[TheSmileyCoder]

I don't immediatly spot anything wrong, are you sure all the values your trying to put into the table are correct? I.e. your not trying to assign a string value to a number field?

[usr123]

Ok. Got it working. I think it was the permission issue. I changed the permissios in sql server for read and write. Then recreated the connection, and did docmd.runsql strSql. It worked.
Thanks for answering my question.