Microsoft Access within Azure

David Miller 1 Reputation point
2021-10-27T14:39:44.733+00:00

As an organisation we are moving our on-prem Data centre into Azure.

Our users (+30 users) use a Microsoft Access database which they do not want to move away from.

We are planning to put the client into a Windows Virtual Desktop.

My question is where I should put the mdb file within Azure. I need to consider performance.

Any help would be appreciated.

Thanks

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Alberto Morillo 32,886 Reputation points MVP
    2021-10-27T22:59:01.717+00:00

    What I have done for customer is the following. I have migrated the Microsoft Access database to Azure SQL. Then we replace the tables on the Microsoft Access frontend application by linked tables. Those linked tables you create them using ODBC. After that your Access applications should work.

    Some post-migration issues you may be facing are explained here.

    One of my customers have heavy use of Access reports, big reports and not issues. But you need to daily defragment indexes and update statistics for better performance.