General information
Category:
Database DAO/RDO/ODBC/ADO
>>>>Hi all!
>>>> I have a question for you, I'm accessing an access database on a network, for that, it's all fine, but the problem is that I have representatives that logs into our network through internet and a VPN connection, it's kinda slow, cause it seem to transfer the complete table before applying the sql request to it, so for a rep., instead of about 1600 bytes for 3 records, it gets 1.6 Megs for 3000 records before getting his list of 3 records, is there a way the get just the 3 records that are for him and not the whole thing?
>>>>
>>>> Thanks for replying.
>>>
>>>Do you have a SQL statement to retrieve only records of this rep or you open the entire table?
>>
>>Voici ce que j'ai:
>>
>>dim dbFAS as database
>>dim rsFAS as recordset
>>dim sSql as string
>>
>>set dbFAS=opendatabase("\\serveur\FAS\FAS.mdb")
>>
>>sSql = "select * from [fas_hld] where [Agent_ID] = '"
>>sSql = sSql & txtAgentID & "';"
>>
>>set rsFAS = dbFAS.openrecordset(sSql, dbopendynaset)
>>
>>merci pour ton aide
>
>Voici ce que je crois mais je ne peux pas te le confirmer.
>
>Dans ton recordset, tu dois avoir quand même seulement 3 enregistrements.
>
>Si tu download les 3000 enregistrements, c'est à cause de Access. Il est très >différent des autres engins. Tout avec Access est traité en local. >Contrairement à SQL Server ou le serveur extrait et te retournes seulement le >data demandé.
Merci, je vais faire des tests avec SQL Server, nous avons la version 6.0 qui dors sur les tablettes, je vais l'installer et voir si le problème est bien Access.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only