Me.Recordset, bound checkbox, Access 2002 crash 
Author Message
 Me.Recordset, bound checkbox, Access 2002 crash

Hi Support,

I too have just came across the bug mentioned below in other posts
several months ago. I have yet to see this bug or a reliable fesible
solution mentioned anywhere outside of this newsgroup. Can someone get
this hurried along with a knowledge base article and hopefully a
feasible solution?

Platform:

Win98 or Win2k (no sp)
Access 2002 sp2, MDAC 2.7
ADP project connected to Sql Server 2000
Form with bound checkbox to underlying field of any type (bit, int,
varchar etc)

To recreate:

Create a new form based on any table or query.
Add a checkbox to the form bound to any field.
In Form_Load add some code that accesses Me.Recordset eg:

    Dim rs as adodb.recordset
    Set rs = Me.Recordset
or
    Debug.print me.recordset.eof

Run form, click on the checkbox
Access crashes

Problem:

If, after the Me.Recordset object is accessed programatically, the
bound checkbox is clicked on, Access crashes.

If, after the Me.Recordset object is accessed programatically, any
other bound field not bound to a checkbox is changed, then the
checkbox is clicked on, Access won't crash.

Possible Solution(s):

Use an unbound checkbox
Use a textbox or other control instead of checkbox

See also:

Bound Checkbox Crashes XP APP (ADP)

http://www.***.com/

Can anyone else recreate this problem?

http://www.***.com/

DESPERATE: Bit fields and form Recordset object

http://www.***.com/

[ADP/SQL Server] Access crash when user update a CheckBox on a form!

http://www.***.com/ %24b...



Sat, 19 Mar 2005 07:37:33 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Pasar consultas a proyectos access / Convert access queries to access projects

2. JDBC Beta Program for multi database data access ( CONNX Access all your enterprise data using JDBC)

3. Known issues with Access projects (Access 2k as a front end to SQL Server 7)

4. Join Access SQLServer Table with Access Table

5. Moving From Access 97 to Access 2000 Projects

6. Access 97/SqlServer 7: Appending Access Tables into Sql Server tables doesnt work for big tables

7. Can't See Access 97 Queries in DTS Access connection

8. Conversion of Access 7.0 to Access 8.0

9. Access MS-ACCESS file from a Linux box

10. Access, ODBC, SQL Server, and Access Write Conflicts

11. Accessing tables in MS Access from SQL Server?

12. Native error 44 and error -2147217887 accessing DB via Access


 
Powered by phpBB® Forum Software