Last post May 27, 2019 08:14 PM by wavemaster
May 23, 2019 03:55 AM|hkbeer|LINK
I have a very simple ASP.Net developed that now runs on my PC on VS.
It is a web form with Ms Access database.
I want to move it to Azure/cloud. The challenge I have now is Access database does not work on Azure's Web App.
If I copy the database to ASP app's App_Data folder it wont work and throw OLEDB12 not registered issue.
So what is my option ?
Any advice ? I have paid Office 365 Business. Can I store the Ms Access database on onedrive and share the link and use it in web.config ?
I dont want to use SQL Server as the db is very simple and it costs a bit and I dont know how to manage it.
May 23, 2019 07:26 AM|Fei Han - MSFT|LINK
Azure Web Apps run in a
sandbox (a secure environment), which does not enable us to do custom installation on server, if it does not support in hosting web application with MS Access database well, you can try to choose Azure Virtual Machine.
Besides, if you have further questions about hosting web application with MS Access database on Azure, you can post question(s) on Azure support forums.
May 24, 2019 04:43 PM|wavemaster|LINK
SQL Compact is still out there.
Simple file that lives in a folder in your app.
May 24, 2019 06:31 PM|Mikesdotnetting|LINK
SQL Compact is still out there.
Kind of. It's actually been deprecated. Support for it stops in 2021. SQLite is the currently recommended file-based data store.
May 24, 2019 08:14 PM|wavemaster|LINK
Much easier to hookup SQL Compact than SQLite, right?
May 25, 2019 08:46 PM|Mikesdotnetting|LINK
SQLite is just as easy to work with.
May 26, 2019 04:30 AM|hkbeer|LINK
Thanks so much wavemaster. So is there a graphical UI with SQL Compact like Ms Access ?
I am exploring this option now.
May 26, 2019 06:17 AM|hkbeer|LINK
May 27, 2019 07:34 PM|Mikesdotnetting|LINK
So is there a graphical UI with SQL Compact like Ms Access ?
May 27, 2019 08:05 PM|wavemaster|LINK
Yes, but it is limited to db operations. It assumes you have your data in one or more tables.
It is much easier to work with SQL Compact or SQLite during the development phase as it is easy to make changes. You are basically working with a spreadsheet representation of your data.
There is no UI suitable for an end-user. You would have to create that yourself in your web app.
May 27, 2019 08:14 PM|wavemaster|LINK
Ok, some more points for you to consider.
SQL Express is the free version of SQL.
Setting it up is as easy as SQL Compact, and using it is as easy as SQL Compact.
If you are going that way you might as well go the SQL Express route since then you can use SQL Server Management Studio.
SQL Compact does not support some of the more advanced functionality you will find in SQL Express.
SQL Compact is a single file you can copy to and from Azure
SQL Express in the Azure environment means you will need a VM, or you are using Azure SQL, which is expensive to use.
You can also find another hosting company that let's you use SQL Express as part of your monthly hosting fee. I am using
Was using Azure before but they are not cost competitive.
It all depends on what you need for your application and what appetite you have for complexity.