Access crash when user update a CheckBox on a form 
Author Message
 Access crash when user update a CheckBox on a form

I have a big problem using Access Data Project.
SW Version: Access XP, SQL Server SP2, Win 2000 Server SP2

Short description:
The problem happen when I have a form with a CheckBox linked to a bit column
of a table/view.
If the form is locally filtrered, every click on the checkbox make Access
crash.

Detailed description, (behavior reproduction):
* create a table T , in that table create a 'bit' column B, and an identity
column ID
* insert some value in table T
* create a view V that extract a set of data from table T (Select * from T)
* create an ADP that access the DB containing T and V
* create a form F based on the view V
* set to the right value to the property UniqueTable (T) and ResyncCommand
(Select * from T where ID=?) of the form F
* on the form F you'll have a CheckBox control associated to the bit column
B
* create a button FILT that when clicked execute he following code (impose a
local filter)
    Me.Recordset.Filter ="ID>3"     'string that impose a filter
    Set Me.Recordset =Me.Recordset  'update the screen

Ok, now if you open the form F, you see all inserted value, and you can
update the
checkbox without problem; BUT after you impose the filter clicking the
button FILT...
every attempt to update/chancge/click-on a checkbox make Access INSTANTLY
crash

My analysis:
* The problem only exist when I impose a local filter (but I need that
filter on the client (it's a client-server App))
* The problem persist even in the column B is an 'int' instead of a 'bit'
* The problem persist even if on the checkbox control I impose the following
event:

        Private Sub checkbox _BeforeUpdate(Cancel As Integer)
          Cancel = True
        End Sub

* The problem persist even if I try to change the checkbox value directly
from the code
* The problem persist even if I try to change directly the recordset column
value from the code
* The only event executed is on_MouseDown, every other event are not reached
* Acces crash 'istantly' after the click on the checkbox, the following
breakpoint will be never reached

        Private Sub checkbox _BeforeUpdate(Cancel As Integer)
      *  Cancel = True
        End Sub

* During the crash, nothing happen on sql server; no type of comunication
between access and SQL Server (I checked this using SQL profiler)
* Strange thing: even if I set checkbox.locked=true, checkbox ISN'T locked
* I searched the net (msdn, technet, www...) for this problem, but I found
nothing

Please, help me!

Thanks, Max



Sat, 11 Dec 2004 17:06:27 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Access crash when user update a CheckBox on a form

2. Access crash when user update a CheckBox on a form

3. Access crash when user update a CheckBox on a form

4. Access crash when user update a CheckBox on a form!

5. Access 2002 Crash when updating boolean on form

6. Me.Recordset, bound checkbox, Access 2002 crash

7. Form event crashing Access 2002

8. Crashing when 2nd user accesses the database

9. access 3033, database crash, no user administration installed!!

10. Updating data from forms emailed to several users

11. Checkbox on bound form sets value to -1 for True

12. EXAMPLE: DataGrid Checkbox based on modifying output of Data Form Wizard


 
Powered by phpBB® Forum Software