Since upgrading to ver8 r&w I am having unexpected problems. I am using Access 2003. 

I see the message above in my log as well as file is encryped or not a database (error code 26)

I have turned off optimizer and deleted the opt file and tried a full reload  but got the message "...did not finish.

I run querys that appear to be working only no data is returned.

I ran sp_optimizeupdatesync  invoiceline and the pop up shows the Invoice table as being worked on (not invoiceline)...then odbc error.

Is there any way to make an access table using a pass through query and having a user be prompted for a beginning and ending date.

It is great when working properly...almost wished I hadn't upgraded.

What steps can I take to fix the issues?  Am willing to start from scratch with my access links.

Thanks

Gary Dlouhy

I don't know which version of QODBC you upgraded from, but the location of the optimizer file has changed since v6 and by the sounds of things your connection settings in MS Access 2003 have the old location. Try unlinking the tables and relinking them.

See: How do I use prompted date ranges in MS Access?  for more.

I upgraded from ver 7. I deleted all my linked tables as re-linking did not help, in my Access db. Then whenever I tried to re-link a microsoft error occurred.  Access closed. I could not relink with this DB   I created a new DSN and new MDB and re-linked the tables.  I turned off multitable sync hoping this would help and changed database folder to the %userProfile% setting.

Then I created a pass-through query with "sp_optimizefullsync salesorderline"

When it ran it showed "optimizing salesorder" not salesorderline.  Why is it doing this? This does not appear to be optimizing my line item tables.

I tried doing a query on salesorderline and what used to take less than a minute is now taking over an hour. I can see the cursor blinking away reading data but not "Optimizing" like it would have in the past.

I set up an sp_optimize pass through on another pc (read only) and again I ask for invoicelineitem table but it optimized only Invoice table.

On PC1 (server) Qodbc ver is 8 with serial no 08...

On pc2 Ver is 8 with serial no 06...

Quickbooks on loading warned me to "rebuild the data".  After doing this and running my query on Sales Order line it again "reoptimized" .  Is this going to happen every time I have to rebuild?  Should I do a re-load all data automatically? 

Also I tried to do a pass-though query in Access 2003 using calldirect and your {fn curdate()}.  I killed the process as I did not have the patience (waited at least 10 min)  to see if it would complete. If I run with >= {d '2007-12-18'} I get data back almost within 15 sec.

I do have ver 8...240

I let the optimizer do a full reload last night.  And so far my queries are running great again.

I am happy my queries are running fast now...however when a SalesOrder Line Item is changed, the data is not being updated.

I even ran a sp_optimizeupdatesync salesorderline command and still changed data is missing.

I ran a calldirect query and can see the new data.

Seem like this problem occurred in an earlier version and now it is back!

My last comment about not updating may be a problem with my Macro. You can delete it.