After Hours

Ask something
Discussion Locked

Access 2010 crash while closing a report

0 helpful
1 reply

by satishmen66

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have a report which has the following code in "form open event property"

DoCmd.ApplyFilter, " "

After I preview the report and I close it, Access stops responding and following are the details of the error message

Problem signature:
Problem Event Name: BEX
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: MSVCR90.dll
Fault Module Version: 9.0.30729.4940
Fault Module Timestamp: 4ca2ef57
Exception Offset: 0006ccb5
Exception Code: c0000417
Exception Data: 00000000
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 13313

Problem signature:
Problem Event Name: APPCRASH
Application Name: MSACCESS.EXE
Application Version: 14.0.4750.1000
Application Timestamp: 4b8bade7
Fault Module Name: MSACCESS.EXE
Fault Module Version: 14.0.4750.1000
Fault Module Timestamp: 4b8bade7
Exception Code: c0000005
Exception Offset: 006d55e4
OS Version: 6.1.7601.2.1.0.256.48
Locale ID: 13313

Additional information about the problem:
LCID: 1033
skulcid: 1033

How can I overcome this problem

1 reply

by robo_dev

The first question would be whether the database is corrupted, since MS Access is really good at corrupting data.

In general, instead of putting that code in the report, put it in the record source of the report instead. Base the report on a query. In the design view of the query, add your filter criteria.

Is this database on the local PC or on a server?

This discussion is closed to new replies.