Hi All,

I'm hoping for some advice -- I need to build a reporting application
using VB 6 and Crystal Reports 9, running primarily on Pervasive 2000i
data. In a couple of places I need to be able to let users add a
little data to what's in the Pervasive-based (LeasePlus) application,
and then run Crystal Reports on data from both. What's the best way
to go about this -- use Access tables with the VB front-end? What
other pieces do I need to have to make this whole thing work?

Thanks so much.


Robin

Assuming that LeaseTeam has provided DDF's and allowed ODBC access into
the database, you're pretty much home free. To keep things simple, I
would NOT alter your LeasePlus database, but would recommend setting up a
second database with your own files in it.

Use whatever mechanism you want to -- just about ANYTHING will access
Btrieve files. VB/ODBC is a good solution for a beginner, but the raw
(native) API will be a speed demon if performance is critical.

You may also wish to examine the Pervasive Data Integrator product, which
is designed to integrate desparate database environments and incorporate
some business logic into the scheduled processes. It has some VERY
powerful tools that help you to do what you need to do here...
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach (AT) goldstarsoftware (DOT) com
http://www.goldstarsoftware.com
*** Pervasive.SQL Service & Support Classes ***
Chicago: June, 2004: See our web site for details!


Robin wrote:

Thanks very much for the advice, Bill.


Bill Bach <bbach (AT) cncdsl (DOT) com> wrote