Access XP restarting with a checkbox field

E

Eleonora

Hi,



I have FormA used to input data into TableA located in a SQL2K Server having
one of the fields as check box (bit, not allow null).

FormB is used to edit data stored in TableA.

When checking/unchecking the box using FormB, Access shutsdown and restarts
(It doesn't do it when inserting new data using FormA). I created a new form
as a test and the problem is repeated.

However, using the SQL Manager, I can add 1 or 0 into the bit column w/o a
problem.

Does someone know what's happening?

Thank you.

Acc xp -> SQL2K
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top