Error when run Upsizing Wizard

[teac86]

Hello,
when I run the Upsizing Wizard in Access 2007, I've got the following
error on some tables:
-> Table was skipped, or export failed
thats all, no more information about the raison why the wizard failed!
Any ideas?

The wizard upsize to a sql server 2005 in an existing database, this
error occurs only in some tables, all other works fine!

Are there any possibility to get more information about this error?

Best regards,
Roland

 

[Tom van Stiphout]

On Tue, 24 Jun 2008 05:14:59 -0700 (PDT), (e-mail address removed) wrote:

Possibly, if you turn on SQL Server Profiler and point it at the
database. You may see some failing statements and be able to figure
out why.
Or you can use common sense and suspect the Upsize Wizard will have
problems with tables that don't have a primary key, that have funny or
long field names or index names, etc.

-Tom.

 

[Tony Toews [MVP]]

Hello,
when I run the Upsizing Wizard in Access 2007, I've got the following
error on some tables:
-> Table was skipped, or export failed
thats all, no more information about the raison why the wizard failed!
Any ideas?

The wizard upsize to a sql server 2005 in an existing database, this
error occurs only in some tables, all other works fine!

Are there any possibility to get more information about this error?

There is a tool from the SQL Server group.
SQL Server Migration Assistant for Access (SSMA Access)
http://www.microsoft.com/sql/solutions/migration/access/default.mspx
that may be more useful than the Upsizing Wizard.

Chances are there is a date in those tables that is before 1800-01-01
or later than 2099-12-31. Or some such epoch dates. There are two
different date fields in SQL Server. One is much more restrictive in
the allowed dates than Access is.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/