[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


Is there an interface for Peachtree Quatum 2009 to Access 2007?

Posted on 2009-02-13
Medium Priority
Last Modified: 2013-11-15
I want to be able to analyze the information in peachtree.  I am not looking to write back into Peachtree from Access.  Is there an application to link the tables or export them access.  Is this a good way to analyze Peachtree.  

I am a financial analyst and need flexibility.  I am confused as to learn Crystal or stay with Access. with interaction of excel.  Any recommendations on that too?

I want to be able to create reports and financial analytical functions such as forecasts, unit costs, trends, financial reports, etc.

Question by:easycapital
  • 2
LVL 85

Accepted Solution

Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 2000 total points
ID: 23636621
This one appears to do it:

As does the Peachtree SDK, if you wanna take the time to learn it:

As to Access vs Crystal:

I use both, and Crystal is a more powerful and flexible reporting program, but then you'd expect that since that's the business of Crystal. There are some drawbacks - if you need to distribute these reports to others, there can be some pretty hefty licensing fees through Crystal, and Crystal can be difficult to learn. It is, however, one of the oldest reporting engines out there and one of the best. And remember that Crystal is JUST a reporting engine, nothing more - you cannot interact with it like you could Excel, for example.

I do a good bit of work for clients in the financial industry, and have found Access, at times, to be lacking in features needed for the massive amounts of data (and calculations) required. I've always been able to work around it, but most often find myself writing unbound reports and using VBA and queries to do this. Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.

So - all in all, as with anything involving computers, it comes down to your needs. I personally don't think you can go wrong with Crystal IF it suits your needs.
LVL 18

Expert Comment

ID: 23636667

Author Comment

ID: 23640288

What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports."

1) I need to do a lot of variance analysis, forecasting based on assumptions & trends analysis, then graphing it, finding out unit costs, monthly averages, etc.  Is something complex in Crystal?  Is there an online educational site, of course, besides probably the one offered by BO, which is probably very expensive and not such a good bang for the buck?

2) Do you recommend that I learn a different program other than crystal?

3) I was thinking to go after the business owners and offer them consultant assistance analyzing their business right out of PeachTree, then I think I would be forced to use Crystal I supposed.  Is there another software solution that I could use instead, I have hear horrors with crystal.  I mean whatever report I used for one client, I would like to be able to use it for the next, if it applies.  Would the licenesing issue give me a problem.  I believe every PeachTree user has the crystal reader, am I right?

LVL 85
ID: 23640411
<What do you mean by:  "Crystal probably would have easily been able to handle this, but then it wasn't an option for these reports.">

I mean the client didn't have Crystal and didn't want to invest in it. This was working with SQL Server data and an Access Frontend.

First and foremost: I am no Peachtree expert. I've used it in the past, but that's as far as my experience goes with it.

1) Given your requirements, it would seem to me that Crystal would be a better platform than Access.

2) I'm only familiar with Access and Crystal, but there are plenty of other reporting platforms out there. ActiveReports is one that seems to be pretty popular, but Crystal is by far the most widely used (since it's been included in VB since the early days).

3) I wouldn't dream of trying to figure out the Crystal licensing, but so long as THE CLIENT doesn't need to make changes to the layout/format of the report, then you should be okay if Peachtree uses the Crystal viewer. I'm not so sure of that, given this link I found when searching for "peachtree crystal):


Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question