No Data in Access from QB8 |
Author |
Message |
|
Posted : 2008-05-13 07:35:31 |
I can retrieve data from the sample company, but when I link to my live data, nothing shows up. The table is linked but it does not have any rows. I am using XP Pro SP2 with QB Ent 8 Contractor Edition. I am linking to Access 2007. |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-13 10:37:57 |
|
|
|
|
Posted : 2008-05-13 11:09:08 |
I followed the instructions but I still cannot retrieve data. An OPT file is created (6kb), and I deleted and recreated my linked tables. What else could be causing the problem? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-13 13:31:41 |
Try using VB Demo to sort things out, see: How do I use the VB Demo for testing? and check the end of QODBC Message log in the QODBC Setup Screen Messages tab for error messages. You should also be logged in as the QuickBooks Admin account in QuickBooks to connect QODBC for the first time.
|
|
|
|
|
Posted : 2008-05-14 00:51:29 |
I don't have any items in my Start | Programs list, do I have an older version? I just went into QB and selected Setup ODBC. Do I need to purchase a different edition of the ODBC software? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-14 06:44:41 |
|
|
|
|
Posted : 2008-05-16 15:11:56 |
I downloaded and installed. Now I have partial data. For example, in Customer table, the Balance and OpenBalance columns are NULL when I import or link into MS Access. However, values show whenh I use the VB Demo. What could be the problem? |
|
|
|
Tom |
|
Group | : Administrator |
Posts | : 5510 |
Joined | : 2006-02-17 |
|
Profile |
|
Posted : 2008-05-16 15:26:40 |
|
|
|