Upsizing Access 97 to SQL 2000

[kjclark]

When upsizing my Access 97 database to SQL server - I am getting an "Overflow" message - does anyone know what this means and how to fix it? Because of this message, my tables are not upsizing to the server.

Any thoughts or suggestions are much appreciated!

Thanks!
Karla

 

[Stickarm]

What does the overflow message refer to?

Phil

 

[kjclark]

The Overflow message refers to the SQL server - the upsizing tool will let me go define a new dsn, but when I try to proceed, it connects to SQL, but it won't move the data due to overflow - does this make sense?

msn.com info says there is a work around by going Access97 to SQL 7.0, then up to SQL2000 - but I wonder if there is another way...

Thanks for your help!
Karla