I recently purchased the dirver and installed it. There were no problems during installation.

I am using QB 2007 Premier on an Windows XP machine. I am accessing the data through MS Access (Office 2003).

A simple query

SELECT *

From TimeTracking

does not return the expected result.  I installed the driver last week and we had timesheet records through 6/10. This week, we have timesheet records through 6/17, yet they will not return in the query.

I think that it has something to do with the optimizer, but I cannot get the optimizer to "reload all data" or to "load updated data" without throwing an error. Also, I cannot change any of the optimizer settings.

Does anyone have an idea as to what is going on?

Thanks

Ok, please see: How do I setup the QODBC Optimizer? Where are the Optimizer options? on how to setup the optimizer.

Using VB Demo, reoptimize your TimeTracking table by running:

sp_optimizefullsync TimeTracking

Then do: How do I use prompted date ranges in MS Access? except with the Timetracking table.