My ms access application has a continues form that uses a sql query for its data source.
In this form, a check box is bound to a table field (the value is 0 or -1).
Now, I have a weird problem. Sometimes ticking the check boxes in the form, updates the fields in the table and works perfectly fine, but sometimes when i try to tick the check boxes, it just hangs and after a while it shows me a message box with "Timeout Expired".It does not update the table filed.
Can anyone help me with that? I need to fix it ASAP.