Changing access database connection string

Question

In my application i have a access database with a list of customers, this database is imported in my project. A combobox datasource is set to display all the customers.

I also created a form so the user can change some settings and locations of certain files. for this i use the this.properties.settings.KlantenDB() the string is created and will save the path to the customer database.

How can i change the current Access database connection string so it will use the KlantenDB path?

enter image description here

Thorsten Dittmar · Accepted Answer · 2012-10-29 13:30:21Z

1

Call

AppDomain.CurrentDomain.SetData("DataDirectory", path);

and provide the full path to the data files.

The KlantenConnectionString should provide the full connection string. That |DataDirectory| part of the connection string will be replaced with the value you set using the above call to SetData.

In your case, the following call should work

AppDomain.CurrentDomain.SetData("DataDirectory", "C:");

answered Oct 29, 2012 at 13:30

Thorsten Dittmar

56.9k10 gold badges95 silver badges145 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

PandaNL Over a year ago

This works great. Ended up with this. string klantenDBstring = Properties.Settings.Default.KlantenDB; int index = klantenDBstring.LastIndexOf(@"\"); if (index > 0) klantenDBstring = klantenDBstring.Substring(0, index); AppDomain.CurrentDomain.SetData("DataDirectory", klantenDBstring);

Thorsten Dittmar Over a year ago

Just for the sake of completeness: Never use something like LastIndexOf on path names. There's a Path class with methods you can use: string path = Path.GetDirectoryName(Properties.Settings.Default.KlantenDB);

Collectives™ on Stack Overflow

Changing access database connection string

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related