Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. manojab

    Update bit Field in Access using SQL linked Tables

    Here's what i found out....if you change the compatability options under SQL 2000 to SQL Server70 instead of 80 then it works fine.... to get there right click on a data base, then properties, then options & under that u will see a drop down called Compatability Level hope this helps if anyone...
  2. manojab

    Update bit Field in Access using SQL linked Tables

    Yea it works when i use true or false in the query but in all my applications I use 1 and 0 or -1 and 0 for true or false. coz SQL7.0 translates the boolean just fine... but SQL 2000 fails to do the translation So if i start using true or false.. i will have to change all the update queries in...
  3. manojab

    Update bit Field in Access using SQL linked Tables

    thanx for the reply.. but when i try the same query with Access 2000 front end and sql 7.0 back end..it updates the field with no problems!!! thats what i don't understand!!!
  4. manojab

    Update bit Field in Access using SQL linked Tables

    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 =...

Part and Inventory Search

Back
Top