Hi,

Could you tell me please how can I open a connection to an access database located on a shared folder?

Thanks in advance,

You can create DSN and use ODBC model in your .net application.

I know how to connect to MS Access database in a local folder, but my problem is that I don't know how to do this if the database is in a shared folder.

I tried to use this connection string in a Windows application but unfortunately it failed:

When I execute the program, the compiler show me that the database: C:\Documents and Settings\...\@\ServerName\SharedDocs\CS\db1.mdb is not a valid path.

Thanks for your help

Because '\\' means relative path!! not shared path

Can we have access to the shared folder using the OleDb and not the OCDB.

thanks

UNC path, browse it, I developed application runs on db in shared location.

You don't have enough back slashes in there.

If it's a UNC path like this:

\\server\sharename\file.mdb

in C# it would look like:

"\\\\server\\sharename\\file.mdb"

or @"\\server\sharename\file.mdb"

the @ symbol will make it a string literal that doesn't need to be escaped with the extra backslashes.

Hi,

Thank you all for your answers. I tried what "alc6379" recommended me and it works now.

I'm sorry; I didn't answer you before because I didn't receive any message from DaniWeb. No notification messages were sent to me and I don't know why.

HI guys,

i am getting error :
System.Data.Oledb.OleDbExcption : Sybtax error in INSERT INTO sataement.

here a part of my code :
public void Submit()
{
objCommandBuilder = new OleDbCommandBuilder(aAdapter);
// Obtain a new DataRow object from the table Call_Log
insertedRow = table_Call_Log.NewRow();

//CallerComboBox.SelectedItem.ToString();
// Set the DataRow field values as necessary.

insertedRow["Calling_Rep"] = "calling rep";
//insertedRow["Date_of_Call"] = DateTime.Now;

insertedRow["Unnecessary_Call"] = CheckBox1.Checked;

try
{
// Pass that new object into the Add method of the DataTable.
table_Call_Log.Rows.Add(insertedRow);

// Begin send changes to MS Access
aAdapter.UpdateCommand = objCommandBuilder.GetInsertCommand();
//aAdapter.UpdateCommand = objCommandBuilder.GetUpdateCommand();
aAdapter.Update(aDataSet,"Call_Log");

}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}

any suggestions ?
thanks