ADP中的记录集类型 [英] Recordset Type in ADP

问题描述

更改Access ADP

中表单的Recordset Type属性是否会影响可能的记录锁定？


我有一个连续的表单是一个表但我不想要它

可编辑，所以如果我使它成为快照而不是可更新的快照将

这以任何方式提高性能并减少/删除记录锁定？


谢谢，

lq

解决方案

2005年11月16日17:21:13 -0800，Lauren Quantrell

< la ************* @ hotmail.com>写道：


是的。

你总是想为你的

表单选择最简单的记录集。在代码中打开记录集时相同。一个草率的记录集会产生

错误。


-Tom。

更改记录集类型Access ADP中表单的属性
对可能的记录锁定有什么影响？

我有一个连续的表格绑定到一个表但我不想要它
可编辑，所以如果我使它成为快照而不是可更新的快照将以任何方式提高性能并减少/删除记录锁定？

谢谢，
lq

Tom，

感谢您的信息。


一般来说，我打开这样的记录集：


Dim RS As ADODB.Recordset，mySP As String，myID as Long

myID = Me.SomeUniqueID

mySP =" dbo.sprocName"

设置RS = CurrentProject.Connection.Execute（" EXEC"& mySP&""& myID）

如果不是RS.BOF而不是RS.EOF那么

''提取一些RS（Colu mnName"）值或做其他事情

对人类有价值

结束如果


有没有办法指定一个非 - 动态记录集这样做吗？


lq

2005年11月16日21:47:12 - 0800，Lauren Quantrell

< la ************* @ hotmail.com>写道：

汤姆，
感谢您的信息。

一般来说，我打开这样的记录集：

昏暗RS作为ADODB.Recordset，mySP为String，myID为Long
myID = Me.SomeUniqueID
mySP =" dbo.sprocName"
设置RS = CurrentProject.Connection.Execute（" EXEC & mySP&"& myID）
如果不是RS.BOF而不是RS.EOF那么
''提取一些RS（ColumnName）值或做其他事情真的对人类有价值
结束如果

有没有办法指定一个非动态记录集这样做？

lq

我的理解是这样做会给你一个快照。

Does changing the Recordset Type property for a form in an Access ADP
have any effect on possible record locking?

I have a continuous form that is bound to a table but I don''t want it
editable, so if I make it Snapshot instead of updateable Snapshot will
this in any way improve performance and reduce/remove record locking?

Thanks,
lq

解决方案

On 16 Nov 2005 17:21:13 -0800, "Lauren Quantrell"
<la*************@hotmail.com> wrote:

Yes.
You''d always want to choose the simplest recordset possible for your
form. Same when opening a recordset in code. A sloppy recordset breeds
bugs.

-Tom.

Does changing the Recordset Type property for a form in an Access ADP
have any effect on possible record locking?

I have a continuous form that is bound to a table but I don''t want it
editable, so if I make it Snapshot instead of updateable Snapshot will
this in any way improve performance and reduce/remove record locking?

Thanks,
lq

Tom,
Thanks for the info.

Generally, I open recordsets like this:

Dim RS As ADODB.Recordset, mySP As String, myID as Long
myID = Me.SomeUniqueID
mySP = "dbo.sprocName"
Set RS = CurrentProject.Connection.Execute("EXEC " & mySP & " " & myID)
If Not RS.BOF And Not RS.EOF Then
''Extract some RS("ColumnName") value or do something else really
valuable to mankind
End If

Is there a way to specify a non-dynamic recordset doing it this way?

lq

On 16 Nov 2005 21:47:12 -0800, "Lauren Quantrell"
<la*************@hotmail.com> wrote:

Tom,
Thanks for the info.

Generally, I open recordsets like this:

Dim RS As ADODB.Recordset, mySP As String, myID as Long
myID = Me.SomeUniqueID
mySP = "dbo.sprocName"
Set RS = CurrentProject.Connection.Execute("EXEC " & mySP & " " & myID)
If Not RS.BOF And Not RS.EOF Then
''Extract some RS("ColumnName") value or do something else really
valuable to mankind
End If

Is there a way to specify a non-dynamic recordset doing it this way?

lq

My understanding was that doing it that way would always give you a snapshot.

这篇关于ADP中的记录集类型的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！