[RESOLVED] Getting the Recordcount

[charmedcharmer]

Hey guys a lil help pls...

Dim objDB As ADODB.Connection
Dim rs As ADODB.Recordset
 
Private Sub Command1_Click()
   rs.Open "select * from card_Header", objDB.ConnectionString, , , adCmdText
   Debug.Print rs.RecordCount
End Sub
 
Private Sub Form_Load()
  Set objDB = New ADODB.Connection
  Set rs = New ADODB.Recordset
  objDB.Open "provider=microsoft.jet.oledb.4.0;data source=D:\Documents and Settings\Ruikeish\My Documents\mrserver.mdb"
 
End Sub

Why does Debug.print rs.RecordCount prints -1? instead of printing the no. of records of the table.

Thanks a lot...

[dglienna]

I knew that I've seen this before.

The RecordCount property will always be -1 when using a Server Side cursor. Change the CursorLocation property to adUseClient.

I just searched for rs.recordcount...

[RobDog888]

Not exactly true. To get a recordcount you also need to specify a
cursor type that supports the recordcount property. The Keyset
cursor or Static cursor types support recordcount property and
use a serverside cursor location.

Also, it depends on the provider that your using.

Third, when you dont specify the cursor type and lock type, the
defaults are used which are adFordwardOnly and adLockReadOnly.
Maybe try this, depending on your provider.

rs.Open "select * from card_Header", objDB.ConnectionString, adOpenKeyset, adLockOptimistic, adCmdText

Best bet is to search MSDN for "Recordcount" because there
are allot of situations that can affect the support of the recordcount
property. For example if your application deletes records in a
dynaset-type Recordset object, the value of the RecordCount
property decreases. However, records deleted by other users
aren't reflected by the RecordCount property until the current
record is positioned to a deleted record.

Also, when you work with linked TableDef objects, the
RecordCount property setting is always – 1.

This is why I say to read the help file for your particular use.

HTH

[dglienna]

I was trying to point him in the right direction. I quoted a resolved thread, so I thought that I had it.

[charmedcharmer]

are there any resolved threads already? well thanks for the help.. ur very helpful.. i'll try both your answers a lil later... ill look for that resolved thread if there is any. kindly post the resolved thread if you find it first.. thanks a lot! i mean thank you thank you thank you thank you....

[dglienna]

I think that it was before the use of the checkmark. It ended in "Thank You" or something to that effect. If you search for the quote, then you should find the post.

[dglienna]

I quoted brucevde:

here

I guess that I assumed that it was resolved. Sorry.

[charmedcharmer]

thanks... just tried your suggestions... it work as i wanted it.. thanks alot... i mean, thank you very much!