>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?