Connecting C# application to online MS Access database

Alexander

Hello,
I have an application made in visual C# which is largely dependant on communicating with an online MS Access database (hosted on jabry.com). It will have several users who are going to update the information on the database, so having it locally is not an option. I have tested it locally, and it works without any problems. I have no idea how to write the connection string for when it is ONLINE though. I've tried a lot of stuff... but nothing is working.

Any help would be greatly appreciated!

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Purushottam Rathore17y ago
Add this key in to web.config file in your application.
<appSettings>
        <add key="connString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Database\Data.mdb">add>
appSettings>
0
Master Billa17y ago
Hi

Use this code to connect MS access database with asp.net
public void ConnectToAccess()
{
    System.Data.OleDb.OleDbConnection conn = new
    System.Data.OleDb.OleDbConnection();
    conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data source= @"path \AccessFile.mdb";
    try
    {
        conn.Open();
        // Insert code to process data.
    }
    catch (Exception caught)
    {
        MessageBox.Show(caught.Message);
    }
    finally
    {
        conn.Close();
    }
}
```
Thank you!
```
0
Mohamed Omar17y ago
You can try to play with one of the connection strings as from the following page: http://www.connectionstrings.com/access
Personally, I would expose Web Services and communicate with the database through web services, since Access is file based database and might not provide an easy way to communicate remotely
0