SSMA - data migration/ schema problem

[samuelgreene]

Hi,

I've gotten my .mdb transferred over using the assistant into the dbo
schema - I'm trying do the same thing but in a schema called Tracker.
I'm able to create the tables in the schema with the tool, but when
migrating data I get:

Preparing table SQL Database Tracker.[tblUsers]...
Migrating data for the table tblUsers from the database SQL Database
Tracker...
Table is not in the right state. Make sure the table is accessible and
not read-only.
Data migration failed.

Errors: Table is not in the right state. Make sure the table is
accessible and not read-only.
Data migration complete.
0 table(s) successfully migrated.
0 table(s) partially migrated.
31 tables failed to migrate.

-----------------

I'm able to insert rows with access, so I'm a little bit stumped. I'm
a member of the admin group.

Thanks for any help.
Sam

 

[samuelgreene]

My problem was that I had the tables linked - so do the migration and
then link up. Somewhat obvious, but I figured it would pull data from
the backup tables.