access to sql migration

Hi all;

i am upgrading my db...But everytime i get errors from DTS IMPORT/EXPORT tool...i ve tried many ways but everytime i got error on some parts.

is there any conversion tool for that issue?if not please show me a way in which order i must convert this.which tables first?which scripts first (creating tables,indexes,relationships,storep procedures etc...)

Thank you

thanks micheal

 the access db is corrupted a bit for example (i am not sure the problem may be about indexes) the DTS tool try to copy the 3000. row but it give error i ve looked the total row count is 2700...so no row like 3000

how can i repair such problems?


and also the system works without copying relations...is it dangeraous to use it without relations?

thank you.