Hi Linda

I doubt there are many new programs being written in Access 2. It was a
great piece of software, and many databases were writing using it. I don't
know Church Windows, but I am guessing that it was written back in the
Access 2 days (around 1994), and the people you purchased it from are still
supplying and supporting it.

Depending how they have set it up (security etc), you may be able to use a
later version (e.g. Access 97) to link the tables in the CW database, and
run a series of append queries to add records to the file (assuming you can
get them out of Greentree CDMS.) If the database is written really well and
not using Access security, that might be feasible. But last time a client
asked me to do that with them, it ended up being really time consuming as
the amount of unnormalized stuff being stored in that accounting program was
unbelievable. Unless your church has thousands of people, it might be
simpler to just enter the data.

None, except existing software (which may be a good reason!). A2.0 works fine
if you have someone to support it. These days, you'd be hard pressed to find
anyone (besides the odd Allen!) who even wants to know about it.

Even all the coding has changed, though A2.0 coding is mostly still
legacy-supported. But it will give any NEWER "Access Developer" the hiccups.
Anything from A97 onwards is basically the same coding.

A2.0 is a short-term solution. Since you seem to be in touch with the supplier
then they should be able to offer a later version (not necessarily drastically
changed). It depends on whether you expect the supplier to maintain it, or
whether you obtained it with source code and might potentially get someone
else to maintain it.

So far as I know, A2.0 works as fine as it ever did on all current Windows. I
still have some myself. I would not recommend it nowadays for any new
purchase. Mainly because I'd then be irreplaceable!!!

Chris

Thanks, Allen and Chris.  The lady that helped the church decide on the
program feels bad because the application used is Access 2.0 but I thought I
read somewhere that it worked better than then newer versions for some
reason that I can't recall.  I was thinking it may have been in one of the
access groups but I couldn't find it anywhere.  I wanted to put her mind at
ease.  I think it's going to be ok because the company does support the
application and we get updates as they come out so I don't see a problem
other than the one import issue.

Linda

I'm not sure I've got this the right way around, but

You asked CW to do the import, and they said that it was too
difficult?

And that was because they don't have a copy of Greentree
or Jade?

If you want, you could export all of your Names and Addresses
from Greentree as an Excel spreadsheet, and then ask CW
to import from that.

It is a little more tricky than just sending off your database, because
you will have to do the export yourself, but the CW people should
be able to handle the import, and may even be able to tell you how
to do it yourself.

(david)