how to change the location of database file dynamically in a

ahmed salah

I work in windows form application works in c# visual studio 2015 connect to database access 2007

my connection as bellow

 
public static string fileName = @"\\192.168.1.30\data\accessqr.accdb";  
  
public string connection = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source={0}", fileName);

it working without any problem

but if i need to move database access file accessqr.accdb in another network or another place

may be no ip 192.168.1.30 available or no drive D: available so that

how to make connection dynamic to accept any network ?

so that i need my connection dynamic and is suitable to any place

what i do ?

2 Replies

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

9y ago
put the connection string in config file and instead of UNC path you can use map drive too.
0
Madhanmohan Devarajan9y ago
Better idea to resolve your issue is to store the connection string values in App.config or Windows Registry.

Also you have to specify the connection string while installing your windows application in any desktop pc.

http://www.c-sharpcorner.com/UploadFile/1a81c5/configuring-connection-string-in-app-config-file-during-runt/

Note: Please mark as accepted answer, if the above answer is useful for you.
0