469,574 Members | 1,643 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,574 developers. It's quick & easy.

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

Nov 2 '05 #1
0 4367

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Remy Blank | last post: by
5 posts views Thread by Christoph Sticksel | last post: by
1 post views Thread by Demboos | last post: by
6 posts views Thread by =?Utf-8?B?RGF2ZQ==?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.