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

Hi John

Dim RsSupplier as ADODB.Recordset
Set RsSupplier = New ADODB.Recordset

RsSupplier.cursorlocation=aduseclient
RsSupplier.Open "SELECT * FROM SupplierTable",
BCdataConnectionString, adOpenStatic,
adLockOptimistic, adCmdText

--
Víctor Koch.


"John Roy" <johnroy@xxxxxxxxxxxxx> escribió en el mensaje
news:dca1s1$hk7$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> 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
> >
>
>


.