I would like to get my database to create a new invoice or receipt in
quickbooks for a given job. Is it possible to make a button on an access
form that sends data over to quickbooks?

Thanks guys

nope. MDB is obsolete and it shouldn't be used for anything; anywhere.

MDB has capacity / scalability problems with a single record and a
single user

get a real ETL tool like SQL Server DTS or SSIS

-Aaron



Craig Armitage wrote:
> I would like to get my database to create a new invoice or receipt in
> quickbooks for a given job. Is it possible to make a button on an access
> form that sends data over to quickbooks?
>
> Thanks guys

You can exchange data with Quickbooks, but you will need an ODBC driver and
all data is not writeable. I have used this driver and found it very slow and
somewhat expensive ($200). There is a newer version which I haven't as yet
tried.

http://www.qodbc.com/qodbc.htm

I've also found this one, but I haven't used it and can't comment other than
to say the price is attractive ($40 to $50):

http://www.bigredconsulting.com/aboutdatalink.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access


"Craig Armitage" wrote:

> I would like to get my database to create a new invoice or receipt in
> quickbooks for a given job. Is it possible to make a button on an access
> form that sends data over to quickbooks?
>
> Thanks guys
>
>
>

"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote

> ... you will need an ODBC driver and all data is
> not writeable. I have used this driver and found
> it very slow and somewhat expensive ($200).
> There is a newer version which I haven't as yet
> tried.
>
> http://www.qodbc.com/qodbc.htm

To add to your comments, within the past year, I was investigating this. I
found the site you reference to have very detailed descriptions of the
QuickBooks tables, and the full "Pro-version" QODBC driver, in a
time-limited trial version, was available for download.

I didn't do enough with it to offer any observations on speed.

Larry Linson
Microsoft Access MVP