Upsizing Wizard

[shamas21]

Hi All

I have SQL Server 2005 on my local machine.

Im trying to use the upsizing wizard onto the SQL Server 2005 but I get a message when I click the upsizing wizar that says "ODBC-Call Failed"

Can someone tell me how I can fix this problem?

Thanks

 

[FoFa]

Have you supplied SQL security and have security on the SQL server to do this?

 

[SOS]

What version of Access are you using? You may need to go look for and download the SQL Server Migration Assistant (SSMA) from Microsoft (free) as your version of Access may not support SQL Server 2005 with the upsizing wizard. And besides, the SSMA is better anyway.