I have been running a MS Access with Quickbooks Enterprise for awhile
now pretty successfully. I have written customized queries and
packing lists with it because I don't like they way the standard
packing lists look in Quickbooks.

For the last year I have been using QB 7.0 with the QODBC driver that
came along with it. I have had two problems that have been solved by
the "reload all data" funtion in the QODBC reconfiguration tool. 1)
Sometimes credits do not show up in Access unless I reload and 2)
there have been a few times where reports take WAY TOO LONG to run
(30 minutes instead of 30 seconds).

I recently rebuilt my entire PC from the operating system up and
installed QB 8.0 with the corresponding QOBDC 8.0 driver. I am now
experiencing an enormous speed problem. The new optimizer (8.0)
seems to run a lot slower, but since I do that overnight it is not my
biggest problem. The real problem is that reports take 30 minutes to
an hour to run. No matter what I do I can not solve it. I have
tried everything I can think of:

1) I turned off all firewalls, visus checking, registry checkers
2) All the latest software updates are installed
3) I have tried running "reload all data"
4) I tried rebuilding the Quickbooks file
5) I tried creating a new Access database and re-linking to the QB
program
5) I tried refreshing all the links.
6) I have made sure nothing else is running and competing with Access
and Quickbooks. I did this by CTRL-ALT-DEL and watching all the
processes. All I see is two Quickbooks files and MS Access trading
back and forth and DOMINATING the CPU processor staying pegged at
100%.
7) I have turned off the optimizer and deleting the .OPT file
8) I have played with settings in the OBDC configuration tool with no
improvement.
9) I tried re-sorting (re-indexing) all the tables in Quickbooks
10) I turned on the verbose feature and it cranks through 500 records
and then just sits there for a couple minutes then repeats.

The reports do eventually run, but the time lag is totally
unacceptable. The only success I had in getting these reports to run
was to "import" the tables... that took a couple hours, but then all
the reports ran almost instantaneously. It is, however a
workaround. If someone puts in a last minute order before our build,
I will no longer be able to accomodate it. Before since the table
was linked, I could put in a last minute order and it would be
reflected in my Access reports.

I turned on "verbose" and the "driver status panel"... and it sits
there for long periods of time saying "waiting on Quickbooks" and the
CPU stays pegged at 100%. The hard drive isn't spanking or
anything... just the CPU... and waiting and waiting and waiting. The
optimizer is set for not going off every time, so that's not what's
holding up the whole show... it just sits there and cranks through
the records real slow. When I spread out the status panels, I can
see what's going on... sometimes it sits there, but usually it's
doing something... but just slow... almost like 1 record per second.

This QODBC functionality was precisely why I bought Quickbooks
Enterprise. I spent thousands on it and pay $750 a year to have it
maintained. I was pretty pleased with how easy it was to use it and
it gave me good results with minimal effort for a whole year... all I
had to do was to create reports and queries in Access which I already
knew how to do. Now it seems I must delve into a whole new level of
tweaking that I never had to do before like making pass-through
queries and using NOSYNC.

I never had to do this before and it worked decent.... now it is
virtually unuseable. I am not getting good help from www.qodbc.com
and I hope someone here can help.

I am desperate and frustrated... I need help to get this resolved.

Please help.

Tim