> What do you mean "Access shuts down and restarts"? I've never seen
> Access crash and then automatically restart itself...
>
> You might want to stick a Profiler trace on the application to see the
> SQL that's being sent to the server and that is (apparently) causing
> the problem. Take a look at
> http://support.microsoft.com/default.aspx?scid=kb;EN-US;280730 and see
> if that sheds any light on the problem.
>
> -- Mary
> MCW Technologies
> http://www.mcwtech.com
>
> On Tue, 28 Oct 2003 12:55:23 +0100, "Eleonora" <nomail@hotmail.com>
> wrote:
>
> >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
> >
>

wrote:

>Thank you Mary.
>ACC does reset itself. When it happens. a backup copy is made and a message
>is sent to MS.
>However, I noticed it only happens when a record is selected by a dropdown
>box. When a record is selected by the next/prior recor selection, then I'm
>allowed to check/uncheck the ckbox.
>Strange but true.
>
>
>"Mary Chipman" <mchip@nomail.please> escribió en el mensaje
>news:qiuspvgj6126pi7eekd2bvdo1uho1vrs5c@4ax.com...
>> What do you mean "Access shuts down and restarts"? I've never seen
>> Access crash and then automatically restart itself...
>>
>> You might want to stick a Profiler trace on the application to see the
>> SQL that's being sent to the server and that is (apparently) causing
>> the problem. Take a look at
>> http://support.microsoft.com/default.aspx?scid=kb;EN-US;280730 and see
>> if that sheds any light on the problem.
>>
>> -- Mary
>> MCW Technologies
>> http://www.mcwtech.com
>>
>> On Tue, 28 Oct 2003 12:55:23 +0100, "Eleonora" <nomail@hotmail.com>
>> wrote:
>>
>> >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
>> >
>>
>