This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 81%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
I have developed ASP.NET MVC Project using Database created in SQL Server
I am using Database first, so I create models from database
I want to change database source from SQL Server to Microsoft Access
This the Connection string in Config file:
<connectionStrings>
<add name="DefaultConnection" connectionString="Data Source=.;Initial Catalog=DatabaseName;Integrated Security=True" providerName="System.Data.SqlClient" />
<add name="DatabaseNameEntities" connectionString="metadata=res://*/DatabaseNameModel.csdl|res://*/DatabaseNameModel.ssdl|res://*/DatabaseNameModel.msl;provider=System.Data.SqlClient;provider connection string="data source=.;initial catalog=DatabaseName;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
</connectionStrings>
The problem is that ASP.NET Project create the User model by code first, but I do need that as I created the User table in database so I not need to create it by code first
The Problem in that Connection String:
<add name="DatabaseNameEntities" connectionString="metadata=res://*/DatabaseNameModel.csdl|res://*/DatabaseNameModel.ssdl|res://*/DatabaseNameModel.msl;provider=System.Data.SqlClient;provider connection string="data source=.;initial catalog=DatabaseName;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
Is your MVC application .NET Framework-based (not Core)? If so I suggest that you use the Forms Authentication which is used in the MVC4 and before. You will be able to use the Access as a store of user information if you can develop a custom membership provider for the Access.
I am using ASP.NET MVC 5, not core
But what is the connection string for MS Access, I am using this for MS Access 2013:
<add name="DefaultConnection" connectionString="Provider=Microsoft.Jet.OLEDB.12.0;Data Source=E:\\Special\\Business\\Dendistry\\Project\\Questionnaire\\Questionnaire.DataAccess\\Database\\DatabaseName.accdb" providerName="System.Data.OleDb" />
But it give me that error:
A null was returned after calling the 'get_ProviderFactory' method on a store provider instance of type 'System.Data.OleDb.OleDbConnection'. The store provider might not be functioning correctly.
Did you change only the connection string while other codes written for the SQL Server remain unchanged?
Yes, I changed only the connection string,
What code that I need to change too?
It seems to me that you do not have a fundamental knowledge to connect an ASP.NET web app to the Access. Please study it first before asking this kind of question. Otherwise we will not be able to communicate as it is something like we talk using different language.
Ok, no problem
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 36%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELH%3C/text%3E%3C/svg%3E)
Hi @mostafa ahmed ,
You can refer to the following line for the connectionstring.
https://learn.microsoft.com/en-us/dotnet/api/system.data.oledb.oledbconnection.connectionstring?view=dotnet-plat-ext-6.0#system-data-oledb-oledbconnection-connectionstring
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;Jet OLEDB:Database Password=MyDbPassword;
Note: EF does not work with Access and does not support OLEDB connections.
Microsoft strongly recommends against using Access in Web applications. For details, you can see the documentation.
https://learn.microsoft.com/en-us/previous-versions/aspnet/jj653753(v=vs.110)?redirectedfrom=MSDN#can-my-aspnet-web-application-use-a-microsoft-access-database
Best regards,
Lan Huang
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.