Thanks It Works well Re:Opening a recordset Table over a VPN

From: "John Roy" <johnroy@xxxxxxxxxxxxx>
Date: Thu, 28 Jul 2005 07:35:29 +0000 (UTC)

Thanks Victor It works well
I hate to be a pain but I also need

First Record
Last Record
Previous Record
Next Record
and Aboslute Position in a where statement

Kind Redards

John Roy

"John Roy" <john.roy@xxxxxxxxxxxxx> wrote in message
news:dc89uj$p5h$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>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:
- Re: Thanks It Works well Re:Opening a recordset Table over a VPN
  - From: Victor Koch

References:
- Opening a recordset Table over a VPN
  - From: John Roy

Prev by Date: Re: Query Execution Error
Next by Date: Over a VPN and Recordsets to move First Next Previous And Last without loading whole Table
Previous by thread: Re: Opening a recordset Table over a VPN
Next by thread: Re: Thanks It Works well Re:Opening a recordset Table over a VPN
Index(es):
- Date
- Thread