Click here to Skip to main content
15,936,975 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hii
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...??
Posted

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 www.connectionstrings.com
 
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