Overflow Error

C

Cheryl

I am trying to upsize my Access 97 database to SQL 2000 using the
Upsizing Wizard. I keep getting overflow errors, even on an empty
database. I followed the steps in Article 165827 and it made no
difference. I can transfer the files using DTS, but I want the indexing,
relationships, etc. from using the wizard. Any ideas?
 
D

david epsom dot com dot au

Single step through the wizard till you find the place that
fails, then fix it. It fails on the version number of the
SQL 2000 server (I think SQL Server went from something like
version 6.5 to version 2000)

(david)
 
D

davidweaverking

I'm trying to upsize from Access 2000 to SQL 2000 and I'm getting the same
"overflow" error. I tried running through the article mentioned earlier but
it only applies to Access 97 and I can't find where the SQL version number
makes any difference. Thanks for the help.

david
 
D

david epsom dot com dot au

It's the same problem: Access 2000 was released before
SQL Server 2000. Update your copy of Access 2000:

http://support.microsoft.com/kb/272384

"Overflow" Error Message When You Try to Upsize to SQL Server 2000

Actually, there are other more obscure causes of messages
like that. If you haven't done this before, you may want
to look at the SSW utility even the free download demo
version may be helpful:
http://www.ssw.com.au/ssw/UpsizingPRO/Default.aspx


(david)
 
D

Dave Noderer

A common issue I have run into is that a date field in Access can be set to
something funky like 1/1/501 but that will not fly in SQL Server (assuming
you are not expecting dates like that).

Dave Noderer
 
Top