Reverse engineer?

[deejay_totoro]

Hello,

I wonder if anyone has any advice concerning this subject.

I have just been handed a database with about 50 tables and around 600000 (!) records!

There are no relationships defined (!) in the relationships window - so its very hard to try and decipher what goes where!

Can anyone suggest any ideas on how to go about "getting into" this system. Any software that could guess what the primary key(s) are and maybe help me unravel the table structures?

Thanks!

dj_T

 

[charityg]

Try Tools->Analyzer->Document

If that doesn't give you enough depth, a free trial of Total Access Analyzer will give you more information than you'll probably know what to do with.

http://www.fmsinc.com/free/demos/index.html#Analyzer

 

[charityg]

Beat to the punch!
I've gotta start refreshing before I post!

 

[deejay_totoro]

Nw

Well,

Thanks for the replies.

I did download it - and it does indeed seem to be a northwind only demo.

dj_T