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
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.
Was this answer helpful?
This error usually occurs if the MS Access database you are trying to connect to is of MS Access...
When your ASP code tries to insert into an Access Database file, you receive one of the following...
The information in this article applies to : Microsoft Access DETAILS For...