Click here to Skip to main content
15,936,975 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I've made a database in server machine using MS Access. And I want to change data from client pc connected through LAN in c#.
how could that be possible...
do i have to add ip in connection string...??

You can use the network shared location of the database, like this.

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\serverName\shareName\folder\myDatabase.mdb;User Id=admin;Password=;

See here[^] for reference.
Share this answer
Your connection across the network to a MS Access db is still file access so you'll have to make sure that the db is shared out from the server so that the client can see it at which point, yes, you will need to add the ip into the connection string.

As a note, whenever you have connection string questions, the first resource that you should use is
Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900