Update bit Field in Access using SQL linked Table
Hi Guys, I need some help to understand this...
I have an application in Access 2000(front end) & I use linked tables from SQL 2000(Back end). I have a table test.. I'm tryin to update a bit field from 0 to 1 using an update query. It does not perform the update.
"Update tblTest set process = 1 where process = 0"
this is a query in access
can you please help me...what am i missing?