Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

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

Forum : Connecting remotely to QB in MS Access via QODBCSearch Forum

Forum Home > QODBC - ODBC Driver for QuickBooks > QODBC v7 Forum

 New Topic 
 
 Post Reply 
[1]  
 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
 

 
Mark Baur, CMA, CFM 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-09-08 21:06:30
Please see: I do not want to install QuickBooks on every machine. How do I setup QODBC Remote? and W2K3 Terminal Server / QB2006 Ent. + QODBC  

  Top 
  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

 

 

 

 
Mark Baur, CMA, CFM 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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.

 

  Top 
  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

 

 
Mark Baur, CMA, CFM 
 
  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 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. 

  Top 
  Mark 
  
 Group: Members 
 Posts: 4 
 Joined: 2007-09-08 
 Profile
 Posted : 2007-09-12 03:29:37
Okay, thank you very much, Tom. 

 
Mark Baur, CMA, CFM 
 
  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to