Hi,
Thank you for infor.
I have tried the test for several times. However, it also return the same result

select * = 6 secs
select count(*) = 57 secs

I am using "\\myserver\c\mydata\data.mdb" to open database. Does it effect performance?

Again, I also tried to have test

select * .... where ... = 9 sec
select count(*) ... where ... = 8 secs

Any ideas?

Thank you