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.
When I was using DNS-System Connections I have not problems with paging data but I have to use DNS-Less Connection now and the Access database Engine says: Microsoft JET Database Engine error 80040e07
- 9 Benutzer fanden dies hilfreich
