Solved

MS Access 2003 Add and Edit forms with a check box cannot uncheck the box after checked

Posted on 2009-04-07
10
490 Views
Last Modified: 2013-12-05
We have a MS Access 2003 program that for some reason with this one machine running Windows 2000 once the user checks a check box on either an add or edit form the user cannot uncheck the box and likewise if they open the edit form and the check box was already checked they cannot uncheck the box.  The program is using a MS SQL 2000 server as the back end for this.  I'm not really sure how else to explain this any better than that.  Thanks in advance for your assistance with this.  
0
Comment
Question by:HandelIT
  • 5
  • 3
10 Comments
 
LVL 1

Author Comment

by:HandelIT
ID: 24089017
Oh we are also using Lead Tools with this as well and the user does have the latest lead tools runtime installed on their machine and all references are updated and accurate as well.
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24089369
Can you get the user to try this at table level?
Is there any code on the checkbox that is being called?
Is the field linked to a SQL Server BIT field, does the BIT field have a default value of 0
Do you get an error message?
Can you try and set the value in code?
Cheers, Andrew
0
 
LVL 1

Author Comment

by:HandelIT
ID: 24089440
Hey Andrew,

This user does not have direct access to the SQL database and they are running on a Novel System so the SQL server is running with SQL Server Authentication.  The fields that are trying to be set are bit fields with no default values.  No error message is returned whatsoever.  Unfortunately with the way this machine is setup I can't really change the code but I can confirm that with other machines I am able to change the value of the bit field with no problems whatsoever.  This appears to be a problem specifically with this one machine which is very, very strange.
0
 
LVL 28

Expert Comment

by:TextReport
ID: 24089475
If this was MDB rather than ADP then I would be looking at the ODBC drivers not sure though with ADP.
Cheers, Andrew
0
Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

 
LVL 28

Expert Comment

by:TextReport
ID: 24089484
Oh and certainly client configuration rather than Access
Cheers, Andrew
0
 
LVL 1

Author Comment

by:HandelIT
ID: 24089512
Yeah the problem was that we updated the code and the references changed.  The user was using Office 2K but then they had a problem after we updated the code with references and the user had to update to Office 2K3.  After they updated their Office is when we started to have this mysterious problem with the check boxes.
0
 
LVL 1

Author Comment

by:HandelIT
ID: 24090544
Ok I am now able to replicate this problem on a terminal server of the customers as well.  So any tips I will be able to try out directly if anyone has any ideas.
0
 
LVL 1

Accepted Solution

by:
HandelIT earned 0 total points
ID: 24092476
Ok this one resulted in a phone call to Microsoft.  The problem is with the check boxes as stated.  However MS released a hot fix for this http://support.microsoft.com/kb/945674  Of course the hot fix does not mention anything whatsoever about check boxes the hot fix states the following
"After you install Office 2003 SP3, you encounter various problems in an Access project when you work with a Bit data type column in a linked SQL Server table "
But this hot fix solved the problem for me and I can now consider this problem closed.  Thanks for all who helped.  At least MS didn't charge us an incident for this since it was related to a Hot Fix problem.
0
 
LVL 1

Expert Comment

by:zgilboa
ID: 24697480
Thanks for the shared wisdom - you saved me many many hours of useless labor right there:)  Note that a newer fix (kb-956722) has become available:
http://support.microsoft.com/kb/956722

Cheers,
zgilboa
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now