Can't link Access table to SQL Azure RRS feed

  • Question

  • I'm trying to migrate an old Access database to SQL Azure so that the data can be access by a legacy VB6 app as well as it's future Azure hosted LightSwitch replacement. In order to test the migration and linking before trying it on the production server, I created a VM in Azure and copied the database to it. That test went very well. The data was migrated to Azure and the tables linked. I was able to access the data from both the legacy app as well as it's replacement.

    When I went to perform the same procedure on the production server, I ran into problems. The data is converted and migrated to Azure but it will not link. I receive the following error:

    Linking tables skipped because the table backup failed.

    What is the issue here? It can obviously talk to SQL Azure just fine as the data is properly migrated over. But I need the tables linked so that both apps can access the same set of data.

    Monday, April 14, 2014 8:57 PM


All replies