I am having trouble doing an SQL date comparison using Access tables and OleDb. I have been successful using an SqlDataAdapter with this type of SQL comparison below:
SELECT * FROM OrderHeaders, CustomerFiles
WHERE OrderHeaders.CustomerID=CustomerFiles.CustomerID AND
(OrderHeaders.OrderDateTime IS NOT NULL AND OrderHeaders.OrderDateTime >= '2007-11-22 08:00:00 AM')
ORDER BY OrderID ASC
but with an OleDbDataAdapter I get "Data type mismatch in criteria expression."
Does anyone know what date format (if any) will work for OldDb and Access?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.