OLEDB Connection Based

Question

How to Access MS-Access database in LAN Connection Using C# Windows application?

Sanjay Kumar · Answer

Hi try this if it's a LAN environment then just create a share to the folder where the file is located and make sure any user who has to open the database has full permissions to the folder on that machine. In the connection string you can reference the database as \machinename\sharename\dbname.mdb. Network Location string connString=Provider=Microsoft.ACE.OLEDB.12.0;Data Source=\server\share\folder\myAccessFile.accdb; https://www.connectionstrings.com/access/