Upsizing Overflow Error

[Arthur Cheung]

I use the upsizing wizard to upsize a db in MS Access2K into MSDE 2000 (Both
are running on my local W2K machine). After answering the wizard questions,
the system returns an error message "Overflow occur" and forced me to cancel
the upsizing process.

How can I solve this problem?
Arthur Cheung

[DCM Fan]

This is almost always caused by DATE fields that have bad data, say, a date
like 2/5/1099. That date is legal in Access, but not in SQL Server.

Make sure that all of your dates are valid SQL Server dates before upsizing.

From ther SQL Server 7 Books Online:

datetime:
Date and time data from January 1, 1753, to December 31, 9999, with an accuracy
of three-hundredths of a second, or 3.33 milliseconds.

smalldatetime:
Date and time data from January 1, 1900, through June 6, 2079, with an accuracy
of one minute.

To play it safe, you should make sure all of your dates are >= 1/1/1900. If you
absolutely need dates prior to that, then make sure they're all >= 1/1/1753,
and pray the upsize wizard uses datetime. If you need dates prior to that,
(maybe your application is tracking composer birth/death dates), then you have
to use a text field.