QuickBooks crashes when opening a linked table in Access |
Author |
Message |
Sam |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-09-04 |
|
Profile |
|
Posted : 2008-09-09 08:02:14 |
I'm in a 30 day trial of QODBC v. 8.00.00.242, using it with qb enterprise manufacturer and wholesale v. 7. The company file is c. 2 years old, c. 625 mb in size.
Using access v. 2003, I was able to create a linked mbd file, and I can open several tables, but they are the smaller, less frequently edited tables like the itemlist and customerlist. When I try to open any of the larger more active tables, for example SalesOrderLine, qb crashes very quickly. The trase log shows the following:
IsAService: False
Error Code: 26
SQLOptimize_OpenOptimizeDBHandle prepare:
SELECT "type", "tbl_name" FROM "SQLite_MASTER"
file is encrypted or is not a database
I get exactly the same results when using the vb demo app; that is, I can open the same tables I can open in access, and the same tables reliably crashes qb in vb demo as in access.
Does anyone have any idea what could cause this or what can be done to keep this from happening?' |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-09 09:42:50 |
|
|
|
Sam |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-09-04 |
|
Profile |
|
Posted : 2008-09-10 03:47:02 |
Thanks for helping.
I disabled the optimizer and deleted the .opt file, then restarted qb and opened my access file.
But I'm getting the same results. I can still open the files I could open before and attempting to open SalesOrderLine (for example) still crashes qb.
Anything else I could try?
|
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-10 22:15:59 |
|
|
|
Sam |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-09-04 |
|
Profile |
|
Posted : 2008-09-11 00:24:12 |
OK that's a helpful tutorial. Thanks. But are saying that I shouldn't expect access to be able to open an entire big table without crashing qb? I was hoping to export whole tables, maybe the entire company file, to another dbms. Is this an unrealistic expectation? |
|
|
|
Sam |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-09-04 |
|
Profile |
|
Posted : 2008-09-11 02:16:20 |
I just tried a query as you suggested. I actually used a simpler query than you had in you example, and I used a very small date range, the first nine days of this month.
Here's the query:
SELECT InvoiceLine.CustomerRefListID, InvoiceLine.RefNumber, InvoiceLine.InvoiceLineQuantity
FROM InvoiceLine
WHERE (((InvoiceLine.TxnDate)>=[Enter Start Date] And (InvoiceLine.TxnDate)<=[Enter Finish Date]));
Even this crashed qb immediately.
Any ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-09-11 22:38:37 |
Try doing:
SELECT * from InvoiceLine unoptimized where TxnDate > {d'2008-06-01'}
using VB Demo. |
|
|
|
Sam |
|
Group | : Members |
Posts | : 5 |
Joined | : 2008-09-04 |
|
Profile |
|
Posted : 2008-09-12 02:22:16 |
QB crashed in about 3 seconds. |
|
|
|