Tables are skipped or export failed error occurs when upsizing MS Access to MS SQL Server

[Bon]

Hello All

I got "Tables are skipped or export failed" error when I used upsizing
wizard on migrating MS Access 2000 to MS SQL Server 2000.

I am changing my application backend database from MS Access 2000 to MS
SQL Server 2000. My front end is MS Access interface. When I used the
MS Access 2000's Upsizing Wizard for database migration, some tables
cannot be migrated. The upsizing wizard report states some tables are
"Tables are skipped or export failed" and some are "updating report
does not have unique idex". Could you telll me how I solve both of the
problems please?

My setting on upsizing wizard:
check the index, validation rules, default, table relationships
check the trigger radio button
no, never use the timestamp
create the link with the existing application

Thanks in advance

Cheers
Bon