| Timesheet Data |
| Author |
Message |
|
|
| Posted : 2007-06-08 00:48:18 |
If I am in the wrong forum, then please point me to the correct one.
What table has the Timesheet data in it? I can see the data in QB without a problem. When I use QODBC and Crystal, I see the TimeTracking database, but it is empty. Any ideas? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-08 09:52:24 |
|
|
|
|
|
| Posted : 2007-06-09 06:46:55 |
I had seen that thread already and tried those steps.
How do I confirm the version of QODBC that I have? I used the the link in that thread to download the latest version, but I just want to confirm that is what it is using.
I also used the Rebuild utility and Verified the Data. Neither chanegd anything. If I point to the sample database, I CAN query the TimeTracking tbale without a problem.
Any other thoughts? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-09 10:21:53 |
| Please make sure you ar running QODBC v7.00.00.214 (see: How can I get the latest version of QODBC? ). If you look at the QODBC Setup Screen "About" tab you will see what version you are running and the status of your QODBC license. |
|
|
|
|
|
| Posted : 2007-06-09 12:18:32 |
| I verified that I am running QODBC v7.00.00.214 |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-09 14:54:47 |
Open one of the sample files to see that you can see TimeTracking data.
Try running:
SELECT * FROM TimeTracking UNOPTIMIZED
using VB Demo against the sample company file and then your company file. You must also use the QuickBooks admin account and have access to personal data.

|
|
|
|
|
|
| Posted : 2007-06-13 23:20:06 |
Where do you get to the properties screen you showed in your last post?
I have been able to run and return data from the TimeTracking table when I use the Sample db, just run into an issue with the Client db.
I used the Rebuild utility and I verified the data, and then reran the query with the same results. |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-14 01:45:15 |
|
|
|
|
|
| Posted : 2007-06-14 02:22:03 |
| I followed that document and everything was setup that way already. Any other ideas? |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-06-14 03:04:38 |
| Yes, get another copy of the client's company file. |
|
|
|