Scenario: Using odbc with Access 2000 and SQL Server 2000.
Problem: After adding a column using the bit datatype to a sql server table, we received an error when trying to delete records from that table from within Access.

The error stated that the record couldn't be deleted because someone else had it open at the time even though no one did.

We tried:
Relinking the table about a million times.
Rebooting the server (once).
Using the linked table manager to refresh the linkage (about 80 times).
Using both machine and file DSNs.

After about 2 hours of futility, we removed the bit datatype column and we were then able to delete records at will.

Question:
Does anyone know if Access and ODBC simply don't like this datatype or if there is a workaround for this problem?

My plan is to try it again using Char(1) instead of bit next time unless I hear of something that might fix this.

Thanks in advance for any help.