Liks to Sage Accounts and Quickbooks
As the new version of Access will allow linking to other databases could the team include Sage Accounting System and Quickbooks. There are many potential add-ons that could and need to be developed to improve both of these accounting packages and interfacing to Access is painful and expensive. This would ensure Access remains the 'go-to' application for all small database analysis.
Ken Mulvihill commented
I am surprised that this doesn't get more votes. I have talked to several Access developers that say it is a royal pain to connect with QuickBooks. I don't know much about Sage.
I will look into QuickBooks SDK.
I agree with Nigel, that an external data connector would be very helpful.
Thanks to Dolly and Albert for mentioning that there are routes to link these Programs to Access.
So, in which case it wouldn't hurt to have on the External Data ->More button 'Sage Accounts' and 'Quickbooks'
Albert D. Kallal commented
A few things. Both the SDK for QuickBooks and also sage is free.
You can download the sage dev kits here:
You don't need to purchase anything.
Also, keep in mind that Sage uses MySQL - so you can connect to and query the data directly if you wish via standard ODBC and you don't even need to use the above mentioned free SDK for sage.
I used the Sage SDK - it is free and I push invoices from Access using the SDK.
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
I'm not so sure that is correct. Have you seen
You are right that QuickBooks has an SDK for the Desktop version.
Sage needs you to join the Developers Programme in order to download the SDK.
This costs a minimum of £1500 per annum.
That is not true. It's been too long for me to comment knowledgeably regarding SA, but QuickBooks SDK is 100%. Never has cost a penny. You can also create a free account on their forum to ask questions in the hopes that someone can help you out. They also have numerous code samples.
For Sage, you need to be a Sage Developer (cost over £1000pa). For QuickBooks a similar situation. You need to buy expensive add-ons to link to Access.
Often as a developer, you need a simple way of adding a transaction or reading a Client address and the cost of buying an add-on is prohibitive. If you think that this suggestion could make life even a little easier for you, please vote for it.
You can already connect to both! There are SDKs and sample code that already exist for this.