Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Databases and VB5
Message
 
To
15/02/1999 16:45:12
Sylvain Allard
Services Informatique Nda
Montréal, Quebec, Canada
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Miscellaneous
Thread ID:
00187828
Message ID:
00187881
Views:
25
>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?
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform