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

Upsizing Overflow Error

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.