Azure MS Access database - best location?

Question

My company is considering migrating our systems to Azure. We have an asp .net web application running with Access Database. My boss doesn't want to use SQL azure just yet - he may want it one day but for now we will stick with ms Access. Where would be the best place to put our Access Database?

I have been doing some tests and it seems to work just fine when it's located in the Azure website directory inside App_Data folder. However, I am not sure if this is a safe approach.

The other option I have read about is putting in on a virtual machine.

I am not sure which approach to take. The point is to keep using MS Access with an Azure website

Thanks

Duplicate. See http://stackoverflow.com/questions/4624347/security-of-app-data-folder-in-asp-net — CSharpRocks, Jun 12 '14 at 12:28
Thanks for this but it's not touching on how Azure treats this — user3733737, Jun 12 '14 at 15:33

score 0 · Answer 1 · answered Jun 12 '14 at 14:51

0

There is one more option i suggest. We keep the access file into Blob storage and make the connection string pointing to a Blob storage path.

answered Jun 12 '14 at 14:51

Ondipuli

468
3
9

Have you actually tried it? How would the connection string look like? – user3733737 Jun 12 '14 at 15:31

Azure MS Access database - best location?

1 Answers1