Access 2000 to SQL Server 2005

N

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
 
B

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

__________________________________
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Express 2008 1
Access Project connect to SQL Server 7
Upsize to sql server overrides sql server default location--why? 3
Cannot link to SQL server 17
Link to SQL Server 2005 2
Upsize to MS SQL Access 2007 2
docmd.transferdatabase access 2003 to sql 2005 2
Upsizing ACC 97 to SQL 2000 1

Top