Microsoft SQL Server Migration Assistant for Access Problem -- "There is nothing to process"
Posted on 2009-04-14
Hi. I am trying to migrate an MS Access 2003 database to MS SQL Server 2005, using the Microsoft SQL Server Migration Assistant for Access.
I have used the Migration Assistant successfully in the past.
Now, however, when I create a migration project, Add the database, connect to my MS SQL Server, and try to "Convert, Load, and Migrate" the MS Access 2003 database, I get an error:
"There is nothing to process."
The migration assistant will not convert, load, or migrate my database. Apparently the Assistant does not recognize or see the database?
Has anybody else encountered this problem? Thanks for any advice.