Access 2000 to SQL Server 2005

[niksbin]

Hi,

I have a database in MS Access 2000. And, I would like to export it to SQL
Server 2005. I found that when I try to 'upsize'/export, I get an 'Overflow'
error, even if there are only a few records in the Access 2000 database.

Can you tell me what might be the problem, and how I can fix it?

Thanks.

Sincerely,
Nikhil

 

[Klatuu]

This may help
Split the database
Upsize the backend

 

[boblarson]

If you are not on Windows Vista, you should be using the SQL Native Client
ODBC driver instead of the regular SQL Server ODBC driver, when using SQL
Server 2005 or SQL Server Express 2005.

If you are using Windows Vista then you need to use the SQL Server ODBC
driver.

That is information straight from the SQL Development team (Mary Chipman)
that we got at the last Pacific Northwest Access Developers Group meeting.

--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com

__________________________________