Opening a recordset Table over a VPN

From: "John Roy" <john.roy@xxxxxxxxxxxxx>
Date: Wed, 27 Jul 2005 15:41:07 +0000 (UTC)

I am trying to open a recordset in a table to find the Recordcount whithout
briging the whole recordset down the vpn line it seems like the code i am
using is wrong ?
Set RsSupplier = New ADODB.Recordset
RsSupplier."SupplierTable", BCdataConnectionString, adOpenStatic,
adLockOptimistic, adCmdTable
Any body know an other way
I only want the RecordCount not the 5000 suppliers list
thanks
John Roy

.

Follow-Ups:
- Thanks It Works well Re:Opening a recordset Table over a VPN
  - From: John Roy
- Re: Opening a recordset Table over a VPN
  - From: Victor Koch

Prev by Date: DBF Updating Error
Next by Date: Re: Opening a recordset Table over a VPN
Previous by thread: DBF Updating Error
Next by thread: Re: Opening a recordset Table over a VPN
Index(es):
- Date
- Thread