Customer Table not accessible #10057 error |
Author |
Message |
|
Posted : 2006-08-16 14:14:34 |
I am running version 6.00.00.155 of the QODBC Driver. When I try to access the CUSTOMER or ENTITY tables from MS Access I get an error " ODBC - Call failed. [QODBC] Error: 1000 - There has been an internal error when processing the request. (#10057)" Basically, I cannot display either of these tables. I do not get this error on any of the other tables. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-16 14:38:02 |
Try disabling "Use Case Sensitive RefNumber Searches".
|
|
|
|
|
Posted : 2006-08-16 18:51:14 |
Thank you, after applying this change the error has now gone. However, now it displays a table with no records in it. Any other suggestions? I have upgraded to the latest release of the software too just to be on the safe side. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-16 22:50:00 |
Changing this setting affects how MS Access sees the table structure. Delete the Customer and Entity linked tables and add them back again. |
|
|
|
|
Posted : 2006-08-17 09:21:34 |
As requested, I deleted the links and re-linked these two tables but got the same result: table displays with all of the field headings but there are no records. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-17 09:36:02 |
Check the tables using VB Demo. If there's still no data, try another company file. The Australian edition of QuickBooks has a nasty habbit of corrupting the company file if too many fields are inserted or updated at once. You may need to go back to a backup of the company file. |
|
|
|
|
Posted : 2006-08-17 09:50:47 |
VB Demo did not return any records either. Tried with the sample data and got data to display. I did already try backups of my company file going back several months but still the same error. Any other ideas? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2006-08-17 10:05:09 |
You can try using "Rebuild Data" within QuickBooks (under File | Utilities), but it sounds like the company file has been corrupted. |
|
|
|
|
Posted : 2007-10-15 10:31:05 |
I'm having this same problem, except with the Invoice table.
I can open up the Sales Order table and Item tables without any difficulty, but I can't get into the Invoice table. If I make a new QuickBooks company, I have no problem accessing the invoice table, which makes me think that the company file that I am using is corrupt.
I'm using Microsoft Access 2003, and QODBC 6. I've tried Rebuild Data utility as well as the suggestion about unchecking the Case Sensitive RefNumber Searches box, which didn't help.
Is there anything else I can try? Let me know if seeing the log would help.
Raja |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-15 10:46:39 |
Use VB Demo and try running:
Select * from Invoice unoptimized where TxnDate > {d'2007-01-01'} |
|
|
|
|
Posted : 2007-10-15 11:00:21 |
Hi Tom,
Interesting... it gave me an hourglass for a couple of minutes, and then started to return about 6000 records (ya, I know, they do good business) ;)
In Access, I also just tried:
SELECT * FROM Invoice unoptimized where TxnDate > #01/01/2007#;
It took a minute or so, but it worked too! Thank you so much. Was it the unoptimized clause which made it work? Or was it a timeout issue?
Thanks again,
Raja |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2007-10-15 15:47:10 |
|
|
|