OLEDB connection string problem pls help

[CoMMiE]

Hi
The following connection OLEDB connection string return an Error:

Dim strConnection As OleDbConnection
strConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='"_
& Environment.CurrentDirectory & "'\Test.mdb;")

Can anyone please point out to me whats wrong?

Thanks

[veryjonny]

Whats the error?

perphaps shd try:

System.IO.Directory.GetCurrentDirectory.ToString

[cim3]

Firstly you don't need to put your data source within ' '.

strConnection = New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= Environment.CurrentDirectory & "\Test.mdb;")

[veryjonny]

missed that