database path to be added in the coding

[raghulvarma]

I am using MS Access and vb.net, Now I have included ms access into the application.whe n I did my coding I did by

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\emp.mdb;_
  PersistSecurityInfo=False")

but when I need to deploy it in client system I cant know in which drive they are going to put that? so how could I change it?

Thanks in advance
Raghul

[lotus18]

I am using MS Access and vb.net, Now I have included ms access into the application.whe n I did my coding I did by

cn = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\emp.mdb;_
  PersistSecurityInfo=False")

but when I need to deploy it in client system I cant know in which drive they are going to put that? so how could I change it?

Thanks in advance
Raghul

Your access database resides in C:\ drive so you should deploy it also in that directory.

If you to make it more dynamic, see this related article


Rey Sean

[truezplaya]

You could look in to putting the connection info into an xml file. This will allow you to specify a genral path. So when the program is installed you just put the XML file in to the location you stated within your program.

This also helps if the location of the DB changes or the name.