Not a valid path ?

[Art W.]

Hello Everyone:

When I run the follow code I keep getting an error message that reads “Not a valid path” See The Code Below”. I have copied the path from the browser and the file name from the properties dialog box. I checked it is a mdb file.

What am I missing?

Is there another way to check the path of the file?

I am using VB 2005


Dim conn As New OleDbConnection()
conn.ConnectionString = "Provider=Microsoft.jet.oledb.4.0;Data Source=C:\Documents and Settings\Art\My Documents\Office\Access\MN\Seeds 1\Seeds 1.mdb;User ID=admin;Password=;"
' C:\Documents and Settings\Art\My Documents\Office\Access\MN\Seeds1
' Seeds 1
Dim strSQL As String = "Select Results from Seeds1"
Dim da As New OleDbDataAdapter(strSQL, conn)
da.Fill(ds)
If ds.Tables(0).Rows.Count > 0 Then 'check to see if the table is empty
txtResults.Text = ds.Tables(0).Rows(0).Item("Results").ToString()

End If





Thanks

Art W.

[Hack]

Does the folder structure exist on your PC?

(C:\Documents and Settings\Art\My Documents\Office\Access\MN\Seeds 1\)

[Art W.]

Hello:

yes please see the comments in the code they are copied paths.

Thanks

Art W.

[sapator]

In the comments you have "Seeds1" in the code you have "Seeds 1"
Check your path again.

[Art W.]

Hello Everyone:

I have tried both with and without spaces. all combatinations.

Thanks

Art

[sapator]

"Select Results from Seeds1"

Seeds1 is a: 1)database? 2)datatable?