When you use a dns-less connection against a msaccess database you cannot use neither msaccess functions (from the server-side) nor using variant data (for instance, gives numeric data when the data is an alphanumeric). If you store the price as alphanumeric you cannot use a CDbl function to know the rows between 10000 and 20000.

SELECT * FROM data WHERE Cdbl(price) >= 10000 and CDbl(price) <= 20000

You have to use properly information such as

SELECT * FROM data WHERE price >="10000" and price <="20000"

Using a DNS-System connection you can execute the first SQL sentence.