upgrading from access 97 to sql 2000

[tziviak]

I'm in the process of transferring over the table to SQL 2000-
so first-I'm transferring the data sturctures-but then how do I know if the relations came through??
where do I see the relations? in diagram?-if it's in diagrams-how come I don't see the relations that I had in access?

because when I transferred-they just ask me what table I want to transfer ( I transferred it using upsize to sql server)
Thank you,

 

[spDavCom]

Ugrade the access 97 to access xp 2002 first!

Then upgrade to sql 2000. You need to use the sql 2000 manager to look at the table relations.

 

[tziviak]

I need to keep it at access 97-so I first upgraded it to sql 7 & then I'll transfer it to sql 2000
so I want to make sure my relationships are preserved in sql 7