Format of the connection string to access an ACCESS database in c# over network?
I want to make a OleDbConnection in c# and connect it to an access database in another PC on my lan.
This is an example of a connection string to connect to a database on my local computer:
(string strconnection = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\DOdatabase\Database.mdb"; and it works)
and this is the connection string of the Database which I want to access :
Provider=Microsoft.ACE.OLEDB.12.0;Data Source="C:\Documents and Settings\mchct\My Documents\c#.accdb"
(it`s access2007 and I got this string from the other pc itself,this computer name is HCTADMINS).
So now How can I change the above string to connect to c#.accdb on HCTADMINS from my local PC.
plz write the string for me,