By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,689 Members | 1,759 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,689 IT Pros & Developers. It's quick & easy.

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

P: n/a
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

Nov 2 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.