I've used Access extensively with Legacy. It is based on an Access 2.0
database. You can look at it with Access 95 and 97, but BE CAREFUL. My
recommended way to look at a Legacy Database is to create a new Access
database and then Link (or attach) to the Legacy FDB file.
Once you've gotten used to it, it's easy. The data can be scattered around
several tables, but if you understand relational databases, it will quickly
make sense. Once you get the field mapping down (email me privately and I
can help you with that), you can slice and dice the data "six ways from
Sunday". I've also posted Access query code to the list in the past for
others to use. Check the archives to find them.
I've moved Legacy data directly into other programs (FO and Living Album
99), and back, and created some reports, such as marriage lists and photo
scrapbooks. I'm working on a program which uses an Access database to store
data that doesn't fit into the Legacy data structure, and it also ties
directly into the Legacy database, so that its always concurrent with
Legacy.
Mark Stoughton
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Chuck
> Huenefeldt
> Sent: Thursday, September 23, 1999 12:54 AM
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: [LegacyUG] Microsoft Access
>
>
> Ray,
>
> Sorry, it sometimes takes me days to wade through Legacy User Group
> messages and most the time it's a quick glance... so you wrote
> this a while
> back. I too have found Legacy's lack of customizeable simple reporting.
> Just recently I've been experimenting with Microsoft Access to manipulate
> databases. Sometimes it's hard to map the right fields (Legacy uses
> extremely abbreviated table names) but it's workable. Have you had any
> experience with using Legacy and Access? Maybe others have customized
> queries or reports already put together? Anyone?
>
> Chuck
>
> At 09:40 PM 9/1/99 -0700, you wrote:
>
> >2. Finally (for tonight), unless I've been asleep again, there
> >doesn't seem to be a way to customize simple reports within Legacy.
> >Today, I wanted to print out a list of individuals that had multiple
> >spouses. I could identify them via one of your very nice, programmed
> >searches, but how do I print that list? All that is needed would be
> >to identify the major fields (perhaps by Number) and then let me
> >compose and print a report in which the individual's name was followed
> >by the names of his/her spouses. If I've missed something, please let
> >me know.
>
