Thankyou for your reply. However the problem has nothing to do with the connection to the Paradox database, I have quite successfully connected to the database using both a System DSN, and a Access Linked Table setup. I am querying all tables within the database with no issues.

I do not believe the date formating is incorrect, however to be sure I have also tried the following with the same results;

dd/mm/yy
dd/mm/yyyy
mm/dd/yy
mm/dd/yyyy
dd-mmm-yyyy

The last format should never pose any issues as the system cannot confuse the order of the day and month.

I changed the date format in regional settings to MM/dd/yyyy and ran the above code with the same result (returned 26-Aug to 10-Sep). I do not think that the regional settings will effect the query criteria as we are passing the date format in dd-MMM-yyyy which cannot be confused by the query engine.

In the ConnectDatabase() Procedure; the following ConnectionString also works;
"Driver={Microsoft Paradox Driver (*.db )};DriverID=538;Fil=Paradox 5.X;DefaultDir=C:\INFOTRAX\Db\;Dbq=C:\INFOTRAX\Db\;CollatingSequence=ASCII"

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

rs.Open "select *, (Format([date], ""dd/mmm/yyyy"")) as FormattedDate from movies where Val(Format([date],""YYYYMMDD""))>=" & Val(Format(CDate(From.Value), "YYYYMMDD") & " And Val(Format([date],""YYYYMMDD""))<=" & Val(Format(CDate(dtto.Value), "YYYYMMDD"))), CN
'rs.Open "select *, (Format([date], ""dd/mmm/yyyy"")) as FormattedDate from movies"
' if first does not work try commenting it out and try the second
If rs.RecordCount > 0 Then rs.MoveFirst
' press Ctrl+G before you run the code (or goto View->Immediate window) and this is the
' debug window. when you type debug.print, it prints to this immediate window
' similar to print, but print will print to the form itself.
Do While Not rs.EOF
Debug.Print rs.Fields("FormattedDate").Value
rs.MoveNext
Loop

After that Pls check this, and configure it all as the format you want, be sure the first two of them to be the same:
1. Configure Date format in Access
2. Configure Date format on Control Panel, (the icon: PLANET EARTH, in Spanish Configuracion Regional) to be the same as you want
3. In your SQL query when you work with dates put this function DATE VALUE( date field) (remember it is part of the SQL query, not of VB code).

How about the look of date field inside your database.Pls post the format...

MyLim, thanks again for your help. However, the problem I am facing here has nothing to do with the date format. I am using the format dd-MMM-yyyy, cannot be misinterpreted by SQL. The regional settings will not affect it.

There are many ways to remove duplicate entries in an SQL or Access database. Most make you temporarily insert an ID field, make a temp table and copy data back and forth, and/or are slow. Here is an easy way in VB6 using ADO to remove duplicate row…

You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…

As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…

Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…