How to access the database over the network

Question

I have a c # application installed on your computer first  and the database on the second computer how can access to the database >>> note ... that the type of database is Access database

Biswa Pujarini Mohapatra · Answer

Provider is basically the oledb reference for access DB and datasource means the path/location of your database. in your case you have to store your db in a shared location and give that folder necessary permission hope it helps

lamasat lamasat · Answer

Excuse me please clarify this conn.ConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0; + @Data source= C:\Documents and Settings\username\ + @My Documents\AccessFile.mdb;

Biswa Pujarini Mohapatra · Answer

you can access the database from any server. if you know the database name username and pasword. public void ConnectToAccess () { System . Data . OleDb . OleDbConnection conn = new System . Data . OleDb . OleDbConnection (); // TODO: Modify the connection string and include any // additional required properties for your database. conn . ConnectionString = @Provider=Microsoft.Jet.OLEDB.4.0; + @Data source= C:\Documents and Settings\username\ + @My Documents\AccessFile.mdb ; try { conn . Open (); // Insert code to process data. } catch ( Exception ex ) { MessageBox . Show ( Failed to connect to data source ); } finally { conn . Close (); } }