Categories: MSDN / DotNet / Java / Scripts / Linux / PHP Ask - La ask - La Answer

Microsoft Access has encountered a problem...

Any help appreciated with this problem --

I have a Microsoft Access 2002 application. The Access
mdb has a refence to DAO 3.6 (not ADO). A form is bound to
a linked table in a second mdb. In the AfterUpdate event
method of a text box, after a SaveRecord, a method is called which is in a
GlobalMultiuse class in an ActiveX code component that I
compiled in VB6. In this method, a DAO recordset is
opened on the same record in the same database table that
the form is linked to, and then, some
fields of the record are modified with rs.Edit / rs.Update, and
then the recordset is set = Nothing. These
modified fields are also shown on the Access form.

I have tried this technique on a small test app, and all
works fine: the changes appear on the Access form.

However, in my app, the AfterUpdate results in:
"Microsoft Access has encountered a problem and needs to
close. We are sorry for the inconvenience."

Clicking a button brings up s screen that says ModName =
dao3600.dll.

I have seen this message in other Access apps, but
usually I can compact & repair or import all objects into
a new MDB and that fixes it. Here though it happens every
time.

Any ideas how to proceed?
[1314 byte] By [bobclemens] at [2007-11-11 7:56:15]
# 1 Re: Microsoft Access has encountered a problem...
I would make certain that your code implementation isn't causing a recursive event or refresh of the data to occur in Access. Based upon your description this would seem like the most likely scenario that would cause Access to crash.
pclement at 2007-11-11 23:47:30 >