|
-
Mar 17th, 2013, 08:24 AM
#1
Thread Starter
PowerPoster
clear me please!
With a big amount of recorset data warth is the best in order of performance, with Acces data base?
Set RS = New ADODB.Recordset
RS.CursorType = adOpenKeyset
RS.LockType = adLockOptimistic
or
Set RS1 = New ADODB.Recordset
RS1.CursorType = adOpenKeyset
RS1.LockType = adLockReadOnly
my conn
With CONN
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MF\DATABASE\BAN.mdb;Persist Security Info=False"
.CommandTimeout = 0
.CursorLocation = adUseClient
.Open
End With
in effect i need Readonly or Optimistic????
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|