MS access db not working


#1

Added my MS access DB to wwwroot folder. tried accessing from code as ‘C:\home\site\wwwroot\LauraStock.mdb’. But getting file not found error. Please help!


#2

I don’t think that Gear Host supports reading Access databases from your code. That would require special permissions and libraries. Here is a link to how to read the hosted MSSQL: https://www.gearhost.com/documentation/connect-to-a-mssql-database


#3

We do support access database connections. If you are still having issues please open a support ticket so our admins can take a look into this.


#4

Is there a FAQ or other information on connecting to an Access DB? I was told a while back that Gearhost no longer supported this. Thanks!


#5

Hello,

You can follow this guide from microsoft: https://support.microsoft.com/en-us/help/300382/how-to-create-a-database-connection-from-an-asp-page-in-iis