hi tim

please post your extremely well researched question to our support
forum at forum.qodbc.com for immediate action. we did have to make
changes to the 8.0 driver speed because of accuracy issues in
QuickBooks SDK, you can get more details from tom. thanks!

brad

--- In qodbc@yahoogroups.com, "avalon_acres_farms" <farmer@...> wrote:
>
> 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
>