Re: ADP Check Boxes not deselecting

Tech-Archive recommends: Speed Up your PC by fixing your registry

There's a known bug in SP3 with SQL Server bit columns. Search Microsoft's
site for the hotfix.

"SimeonD" <simeond@xxxxxxxxxxxxx> wrote in message
news:Or0Rt6z4IHA.3480@xxxxxxxxxxxxxxxxxxxxxxx
Hi
This is driving me mad, I'm hoping some one can help me. I have several
forms, each of which contain check boxes. The check boxes are based upon
SQL fields which have a bit data type.
Works fine on 95% of pcs. However, there are a few with a strange problem.
For certain users, ticking the box works fine. However, they cannot then
untick the box. If they exit the form, and then open the form again, the
box can be unticked. But only one box - must exit the form and then go
back in to untick another box.
So its like the record gets locked, then Save on the exit unlocks it. All
the effected PCs have the full Access 2003, on service pack 3.
Any ideas?
Thanks




.

Relevant Pages

  • ADP Check Boxes not deselecting
    ... The check boxes are based upon SQL ... If they exit the form, and then open the form again, the box ... to untick another box. ... the effected PCs have the full Access 2003, ...
    (microsoft.public.access.adp.sqlserver)
  • DB connection Q:
    ... I was wondering what happens to the SQL Server db connection when I exit ... Does Access logoff the connection automatically or should I us some ... Ha eliminado 2127 correos spam hasta la fecha. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Connecting to Remote SQL Server
    ... Now I do get an Error as "SQL Server does not exit or Access Denied". ... there anything I've to do in the Server?(the Machine where windows 2000 ... >> I'm trying to connect a Remote SQL Server which resides in my local area ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: ESENT 215
    ... SQL Server 2000 SP4 ... specified is invalid" ... Setup will now exit" ...
    (microsoft.public.windows.server.sbs)