re-structuring data-- conversion question

[faddat]

Right now I'm working with what used to be a 100-meg access 97 database. After converting it to Access 2002 using Access 2003 (!?) I was able to connect to it using OO.o Base m79. This database is from an older, poorly updated proprietary database. So right now, I've got a whole lot of tables, and no connections between them. Is there any way to create connections between tables automatically?

My end intent is to be able to visually analyze the data. Stored in this database is info like client name, address, business address, phone number, notes, etc. So, each of the individual tables contain info like that, but it is not connected to a client name. Is there any way to auotomatically restore the connections between names and fields? I am not terribly up to speed with either access, or base. The goal of this project at the moment is to be able to set up these pieces of data as "flatly" as possible (possibly CSV) so that I can get them moved into ACT!

Heck, is anyone aware of open-source alternatives to ACT!? I'm trying to track sales, etc. Does anyone have any clues on what I should be doing? I'm just trying to get the database into a "browsable" structure again so that I can set it up for export.

Thanks!

-Jake
_________________
Jacob Anthony Gadikian
Business Technology Specialist,
Student of History and International Studies
716-912-8357
AIM: faddat
SKYPE: faddat
faddat.blogspot.com

[acolvin]

You could try dbdesigner which is opensource (or similar) and written in Kylix. I can do the analysis for you and create links in the design.

Hope this helps
Andrew