MS Access Table Link Issue after SQL db Migration to AZURE

Question

Hi

I have an Access App that used linked tables through odbc from a local SQL Express Server, which works great :)

The goal is to provide this app with data in the cloud so that users can be somewhat mobile.

I eventually got my trial AZURE SQL database setup and after some ups and downs managed to migrate the database from the local SQL Express Server to my AZURE SQL Database with the AZURE Migration Assistant App. Happy Days :)

In the Access App I changed the ODBC connection string to match that of the AZURE ODBC and the Access App reports an active connection, more happy days. :)

However, things stop working there. the DSNLess conection to the linked tables fail, which previously worked fine to the SQL Express Server.

In the Access App I tried a manual external data link to the AZURE db and successfully got the tables list from AZURE, but my tables are missing from the Link Tables list. While I can see them and run queries on the on AZURE and AZURE Data Centre. they are not visible to Access App External Data list of tables.

Im so close to this working, if anyone has any clues to help over this last hurdle Id be appreciative :)

Many Thanks
Jerry

Answer 1

You need s add service Migration. On your table SQL.