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 DSN-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?

 Print this Article

Also Read

Where should I upload my Access database files?

The information in this article applies to: Microsoft Access DETAILS You should see a...

I receive error '80004005' when my ASP or ASP.NET code tries to insert into an Access Database. How do I resolve this?

When your ASP code tries to insert into an Access Database file, you receive one of the following...

I get a '[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'.' error when trying to access my ASP or ASP.net application. What does this mean?

This error usually occurs if the MS Access database you are trying to connect to is of MS Access...