Converting from ACCESS97 to MSSQL70

[Averno]

I tried to convert an access97 database into sql70, but, after the conversion, all the relations got lost. Is there a way to follow to COMPLETELY convert the DB (tables and diagram/relations)?|-I Thanks a lot, bye.
Averno, Italy.

 

[petermeachem]

No, actually. I'm doing the same

 

[Averno]

OK, so: are you re-generating all the table relations "by-hand"? B-( Thanks a lot, bye.
Averno, Italy.

 

[petermeachem]

Yes, I don't actually use the relations stuff. It only works if you are using Access and stop you doing things like deleting tables. I find it a pain, so if I want to delete related records, I delete them in code etc. Much easier I reckon.

I found that Access front end and SQL back end redrew a 'continuous form' form amazingly slowly. I'm not sure why. I produced a copy of the form in vb6, and the performance was much better, again not sure why.