Access 2013崩溃 [英] Access 2013 Crashes

问题描述

嗨我有适用的应用程序 在旧版本的办公室，包括2010年罚款，但它的某些部分导致访问2013年崩溃，错误消息Access已停止工作和以下详细信息。

这似乎发生在我创建时并使用与SQL服务器的直接连接打开ADO记录集，并且select语句不返回任何数据，记录集自动打开正常但是当我将该记录集分配给表单记录集属性
时它会导致可以在下面找到问题示例代码。

详细信息：

问题签名：

 问题事件名称：  BEX

 应用程序名称：  MSACCESS.EXE

 申请版本：  15.0.4535.1507

 申请时间戳：  52282965

 故障模块名称：  MSACCESS.EXE

 故障模块版本：  15.0.4535.1507

 故障模块时间戳：  52282965

 例外抵消：  008a7812

 例外代码：  c0000409

 例外数据：  00000000

 操作系统版本：  6.1.7601.2.1.0.274.10

 区域设置ID：  2057

有关此问题的其他信息：

  LCID：  1033

  skulcid：  1033

在线阅读我们的隐私声明：

  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

如果没有在线隐私声明，请离线阅读我们的隐私声明：

  C：\ Windows \ system32 \\\-US \ _erofflps.txt

示例代码

Dim rst As New ADODB.Recordset

Dim strSQL As String

dbConnection'创建open中使用的db变量声明如下：
rst.CursorLocation = adUseClient

strSQL =" select * from supplier_chargMissingNumberseSummaryview" &安培; IIf（Len（StrFilter）<> 0，"<& StrFilter，"）

rst。打开strSQL，db，adOpenStatic，adLockReadOnly

设置Me.Recordset = rst'这是导致崩溃的行

rst.Close

设置rst =无
CloseDBConnection

---

关注Dagz

解决方案

这个

设置Me.Recordset = rst

是吗？

设置rst  = Me .Recordset

Hi I have application that works  fine in older version of office including 2010 but some sections of it cause access 2013 to crash with the error message Access has stopped working and the following details.

this seems to occur when I create and open an ADO record set using a direct connection to an SQL server and the select statement returns no data, the record set it's self opens fine but  when I assign that record set to the forms recordset property it causes the issue sample code can be found further down.

Details:

Problem signature:
  Problem Event Name: BEX
  Application Name: MSACCESS.EXE
  Application Version: 15.0.4535.1507
  Application Timestamp: 52282965
  Fault Module Name: MSACCESS.EXE
  Fault Module Version: 15.0.4535.1507
  Fault Module Timestamp: 52282965
  Exception Offset: 008a7812
  Exception Code: c0000409
  Exception Data: 00000000
  OS Version: 6.1.7601.2.1.0.274.10
  Locale ID: 2057

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

Read our privacy statement online:
  http://go.microsoft.com/fwlink/?linkid=104288&clcid=0x0409

If the online privacy statement is not available, please read our privacy statement offline:
  C:\Windows\system32\en-US\erofflps.txt

Sample Code

Dim rst As New ADODB.Recordset
Dim strSQL As String

dbConnection ' Creates the db variable used in the open statement below
rst.CursorLocation = adUseClient
strSQL = "select * from supplier_chargMissingNumberseSummaryview " & IIf(Len(StrFilter) <> 0, "Where " & StrFilter, "")
rst.Open strSQL, db, adOpenStatic, adLockReadOnly

Set Me.Recordset = rst ' this is the line that causes the crash

rst.Close
Set rst = Nothing
CloseDBConnection

---

Regards Dagz

解决方案

Shouldn't this

Set Me.Recordset = rst

be this?

Set rst = Me.Recordset

这篇关于Access 2013崩溃的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！