Migration Assistant Access to SQL Server problems


  • I would like to migrate an Access 2003 .mdb to SQL Server 2008 R2 using the migration assistant.

    I did the following in the 'Microsoft SQL Server Migration Assistant Wizard for Access':

    Selected Migrate to SQL Server 2008 (there is no option to select SQL Server 2008 R2), accepted the default location. I then added the database. In the next page, I ticked all the boxes.

    If I drag over the .mdb, I get this message (see below):

    I then created a new database, ticked link tables so that it links to the current .mdb as a front end and then got this error msg:

    and then got msg's that the operation failed.

    I am not sure what to do next. I don't know if installing this will make a difference as I missed it out of the procedure: or if this is another issue.

    • Editado meridius10 lunes, 05 de marzo de 2012 17:40
    lunes, 05 de marzo de 2012 17:36

Todas las respuestas