Thanks Francis!
Ok, I am currently using VBA(Access2000) as my front end and SQL2000 as my back end.
I have tried using "ado connection string" and make a query on VBA, but I got a slow response from my sql server.
I have also tried calling stored procedure on sql server but the response is still slow.
My computer specs is Pentium IV, 1.7G, 128MB DDR, and I still have 32GB of free harddisk space.
Is there any other way(faster way) which I can get a faster response from my sql server even if i have a large amount of data in the table that I am accessing to?
Thanks.
I hope I made a clear explanation.