I have a SQL table that is full of Bit type fields, typically i avoid using these because our front-end Access data base hates them if there is a null value..I've tried updating the nulls to 0. I've made sure on the trouble fields that allow null is not checked...i've ensured we have a timestamp. Up until now i got away with re-linking the table after the changes and it started working. One table just wont work no matter what i do. SO the question is - Can i convert these bit fields to INT or TinyINT? In access i created a local copy of the trouble table with structure and changed the data type there, and ran an append query to grab all the info from the original tabl and, then renamed the new table to so all queries and forms now look at the newly created table..i have alot of testing to do but i wanted to see if this would not be a problem if i was to recreate the table in sql with INT instead of BIT and append the data over.