Upsizing Wizard Overflow Error

[Meir Rotfleisch]

Hi

I am trying to use the Access 97 upsizing Wizard to convert Datatables to
SQL server 2000 and I keep getting Overflow error (I tried with several
different databases).(I also tried from Access 2000 Same problem)

I have an ODBC DNS Source that tests fine to connect to the SQL Server. I
can even do Link Table to existing SQL Database.

Suggestions?


Regards

Meir

 

[Tony Toews]

Hi

I am trying to use the Access 97 upsizing Wizard to convert Datatables to
SQL server 2000 and I keep getting Overflow error (I tried with several
different databases).(I also tried from Access 2000 Same problem)

ACC97: "Overflow" Error Message When You Try to Upsize to SQL Server
2000
http://support.microsoft.com/?kbid=279454

Do a search at the Knowledge Base at support.microsoft.com using the
keywords "upsizing" to review the various white papers on upsizing
Access to SQL Server as well as to ensure you have any updates
required.

Also see my Random Thoughts on SQL Server Upsizing from Microsoft
Access Tips page at my website.

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

 

[Can]

You get an overflow error if you are not using the latest
service release for Office.
Microsoft Knowledge Base Article - 272384

-----Original Message-----
problem)

ACC97: "Overflow" Error Message When You Try to Upsize to SQL Server
2000
http://support.microsoft.com/?kbid=279454

Do a search at the Knowledge Base at

support.microsoft.com using the