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.

  • 13 Users Found This Useful
Was this answer helpful?

Related Articles

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...

Powered by WHMCompleteSolution