Forum Discussion

Paul Le Sueur's avatar
Paul Le Sueur
Copper Contributor
Aug 04, 2021
Solved

Access databases in Azure

Dear All,   This is a question about the hosting of Access databases in either an Azure file server or in Azure File services. There doesn't seem to be much official information on this topic (at l...
access
azure
  • George_Hepworth's avatar
    George_Hepworth
    Aug 04, 2021

    Paul Le Sueur You are right' there's isn't a lot of information out there...

    I have only a couple of thoughts and a question.

    • My understanding is that running an Access relational database application in an Azure VM is a good solution, performance wise.
    • I would be cautious about Azure File Services if you want to put a back end there and a front end on a Windows desktop. I had no luck with a setup using Azure Storage Accounts because Windows Explorer could not reach them.

    I don't know if there is a difference in architecture that would support the Azure File Services approach, but it would be good to know one way or the other upfront.

     

    Finally, my question, out of curiosity, and not being argumentative. Why is SQL Azure off the table?

Resources