We have a database created in SQL. We link tables into Access for users to input data. There is a new field added<br>and in Access it should be "yes/no" data type. I am not sure which data type I should put in SQL (don't see yes/no); for now I put in "Binary". <br><br>However, in Access, I couldn't change it to yes/no to get the check box. And I am trying to put in something(0 or1) in that field in SQL, it says "can't edit this cell". <br><br>What should I do? <br><br>Advice needed - I want to take "database design" class (not necessary Access or certain db, just fundamental). I am in<br>Washington, DC metro area (MD, NorthernVA). Any good training vendors for that? <br><br>Thanks.
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!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
SQL and ACCESS Datatype
- Thread starter yuchieh
- Start date
