upsizing error

  • Thread starter Thread starter Ann
  • Start date Start date
A

Ann

I would like to using upsizing wizard in Access 2000 to
convert an Access database to a sql server database.

When I ran the wizard, and hit next button it gives error
message: overflow.

Then I update office Office 2000 SP-3, but still get
message overflow.
I use mix mode for sql server login.

Any suggestions would be appreciated.

Do I also need to update office on the computer where SQL
server is installed?

Thanks in advance
 
Hi,


It looks like you have gone through the following article:

272384.KB.EN-US ACC2000: "Overflow" Error Message When
You Try to Upsize to SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-
us;272384

If you remotely migrating a database to SQL, you need to
be working on the Access install that you will be using
but in the interest of keeping everything streamlined it
would be better to update the Office installation on the
system with the SQL engine.

What you may want to do would be run through Access 2000
and SQL Server 2000 Readiness Update step in the article
(you may need to uninstall SP3):



Good luck.
 
Back
Top