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

Hi Victor do you mean
change RsSupplier.cursorlocation=aduseclient
to RsSupplier.cursorlocation=aduseserver does this not pull down the data
records to the client end of the VPN
kind regards
John Roy


"Victor Koch" <v i c t o r (arroba)correo(punto)waldbott(punto)com(punto)ar>
wrote in message news:ehX%23272kFHA.3656@xxxxxxxxxxxxxxxxxxxxxxx
> 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
>> >
>>
>>
>
>


.