ODBC Linked Tables Convert Tinyint Fields to Yes/No <p>I'm in the process of converting an Access .ADP project to a .ACCDB with linked tables. I know that a big issue when working with a SQL Server backend is the use of nullable <code>bit</code> fields, since Access's <code>Yes/No</code> data type doesn't allow for nulls. So I converted all of my nullable <code>bit</code> fields to <code>tinyint</code>. However, Access is still mapping these fields as <code>Yes/No</code>, and converting all of my nulls to zeroes.</p> <p>Does anyone have any advice for how to get it to stop this? I've double-checked that the fields in question are set to <code>tinyint</code>, and querying in SSMS I see that the vast majority of the records are null. But all I can think to do is refresh or remove and recreate the linked table, and that's not fixing the problem.</p>