|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
If you can't
login and post questions or you are having trouble viewing forum posts:
Click Here
|
Callback
Support |
|
If you live in USA, UK, Canada, Australia or New
Zealand, you can leave us details on your question and request us to call you back and discuss
them with you personally (charges apply). |
|
Click Here
|
Buy Support
Incidents |
|
If you can't find your answer
in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us
private or confidential information: |
|
Click Here
|
|
| Connecting remotely to QB in MS Access via QODBC |
| Author |
Message |
| Mark |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-09-08 |
|
| Profile |
|
| Posted : 2007-09-08 02:53:06 |
I'm doing some work for an organization that does accounting work for nonprofits. They've got all their clients set up on Quickbooks on a "terminal server" at a remote site. I was told that each client is a separate installation of Quickbooks at this site. Both the nonprofits and this accounting organization access the company's Quickbooks data via the host's website. Note: this is not Intuit's website for the web version of QB, nor is it a special web version of the software. They are using the 2006 Accountant’s edition of QB.
I’m creating an application in Microsoft Access that incorporates a lot of the Quickbooks data. An ODBC link to the data would presumably facilitate those parts of the process that involve retrieving data from Quickbooks (and possibly uploading transactions to).
I’ve read the website information on the Flexquarters QODBC driver, and I’m wondering, first of all, whether it will work with this setup. It seems to suggest that it will.
My second question is whether I will need to link to each of the client’s data separately. I get the impression that QODBC somehow links to whatever data Quickbooks is currently accessing. If that’s true, does it mean that I might create one link in Access to the account table, for example, and when I call on the table or any related query it will retrieve just the data for the company that they’re logged into currently? That would be wonderful, if true.
Many thanks in advance for help.
--Mark Baur, CMA, CFM |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-08 21:06:30 |
|
|
|
| Mark |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-09-08 |
|
| Profile |
|
| Posted : 2007-09-09 09:25:47 |
Thanks, Tom. A lot of this is too technical for me -- I'm an accountant, mainly, but I'll pass it on to the tech person at the remote host.
Am I right in that, bottom line, this means:
(1) They will have to do a separate install for each of the clients whose data my customer (the accounting firm) wants to access via QODBC? Meanwhile, my customer also installs the driver (by the way, which version do we purchase?).
(2) My customer can have a single Access application with an ODBC link to various Quickbooks tables, and it will automatically refer to the data for whichever customer account they are currently accessing on the terminal server? i.e. I don't have to create separate Access table links for each of them.
Thanks. -- mark
|
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-10 08:06:45 |
Bottom line....
QODBC is licensed to each computer. A license is required for each computer QODBC is installed on. In the case of the QODBC Remote connector and two customers, you would need three licenses. To use the QODBC Remote Connector you need the DeskTop Edition. Read only if you just want to read data out of QuickBooks or Read / Write if you want to read data both out and into QuickBooks.
You will need to setup a different MS Access mdb or accdb for each customer. |
|
|
|
| Mark |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-09-08 |
|
| Profile |
|
| Posted : 2007-09-11 02:16:59 |
I'm assuming that we're just running QODBC on two computers: the server of the remote host and my customer. The actual nonprofit (the client of my customer) uses the same installation of Quickbooks, but would have no need for the driver.
In that case, are we talking about purchasing two licenses?
I was disappointed by the news that separate Access table links would be required for each of the nonprofits who have an installation of Quickbooks on the remote host. I thought somehow QODBC always pointed to the tables of whatever Quickbooks was looking at currently. Is it because once Access links to it, it actually specifies a physical location on the remote server that it refers to subsequently?
Anyway, I appreciate your assistance and quick replies.
--mark |
|
|
|
| Tom |
 |
| Group | : Administrator |
| Posts | : 5510 |
| Joined | : 2006-02-17 |
|
| Profile |
|
| Posted : 2007-09-11 08:57:28 |
| MS Access stores the full connection parameters when it first connects to QuickBooks, so you need different .mdbs for different QuickBooks company files. You will need a QODBC license for every computer that uses QODBC. |
|
|
|
| Mark |
| |
| Group | : Members |
| Posts | : 4 |
| Joined | : 2007-09-08 |
|
| Profile |
|
| Posted : 2007-09-12 03:29:37 |
| Okay, thank you very much, Tom. |
|
|
|
|