question

DavidMiller-9823 avatar image
0 Votes"
DavidMiller-9823 asked DavidMiller-9823 commented

Microsoft Access within Azure

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

AlbertoMorillo avatar image
0 Votes"
AlbertoMorillo answered DavidMiller-9823 commented

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.



· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Sorry I have been away for a few days.

Thank-you for your message Alberto. Unfortunately I think what you suggest will take quite abit of time to develop and test. What we are looking for is a quick solution with a view to moving away from the Access DB at a later stage.

In theory, I could simply setup a small VM and put the mdb there. And put the Microsoft Access application into a WVD.

I just wonder if this is an overkill.

0 Votes 0 ·