simple question/correction

[muddasirmunir]

i am using the following code for opening the connection

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\graph\Sales.mdb;Persist Security Info=False"

it work fine but only when i place a database on D:\graph\Sales. mdb
i want that it should work even i install my project on any directory or in any folder.

i know there is somting i had to use APP PATH\sales.mdb insted of D:\graph\Sales. mdb which can solve this but i just forget
it and not getting the correct code

[jamesd0142]

i am using the following code for opening the connection

con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\graph\Sales.mdb;Persist Security Info=False"

it work fine but only when i place a database on D:\graph\Sales. mdb
i want that it should work even i install my project on any directory or in any folder.

i know there is somting i had to use APP PATH\sales.mdb insted of D:\graph\Sales. mdb which can solve this but i just forget
it and not getting the correct code

application.sta rtuppath & "\databasen ame"

[mafaisal]

Hi,

Try This


in Vb6

dim DataPath as string
DataPah = app.path & "\Sales.mdb"
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & DataPath & ";Persist Security Info=False"

In .net2005

dim DataPath as string = System.Environment.CurrentDirectory & "\Sales.mdb"

Faisal

[muddasirmunir]

Thanks .

Hi,

Try This


in Vb6

dim DataPath as string
DataPah = app.path & "\Sales.mdb"
con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source= " & DataPath & ";Persist Security Info=False"

In .net2005

 
dim DataPath as string = System.Environment.CurrentDirectory & "\Sales.mdb"

Faisal

[mafaisal]

Hello,

Always welcome

Faisal

Thanks