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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by manojab

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

Part and Inventory Search

Back
Top