Not a valid file name strConnection.Open()

[JaneB19]

Hi,

I'm getting the following error message

Not a valid file name with the line highlighted as strConnection.Open()

This occurrs when I try to retrieve data from my Access 2000 database.

The strConnection is declared as follows:

Dim strConnection As New System.Data.OleDb.OleDbConnection("Provider = Microsoft.Jet.OleDb.4.0;Data Source =

http://localhost/WebApplication1/Project/CrypticCrosswordSolver/Project.mdb;")

I have also been getting an error about not being able to find an ISAM, or something like that. I'm not getting the error this morning, but I'm sure it will resurface!

Any help/comments would be greatly appreciated. Thanks in advance

Jane

 

[cesark]

I'm getting the following error message
Not a valid file name with the line highlighted as strConnection.Open()
This occurrs when I try to retrieve data from my Access 2000 database.

Maybe the problem is the database file pathing. Check your "

http://localhost/WebApplication1/Project/CrypticCrosswordSolver/Project.mdb;"

direction.

 

[JaneB19]

Thank you!

It was the correct loclahost URL, but I've changed it to the C: drive and gone through all the folders instead and it works now.

Do you by any chance know if it is possible to have the database reference as a URL?

Thanks again
Jane

 

[cesark]

I always do it with C: drive. I suppose that it is possible but I do not know exactly how.

 

[JaneB19]

Oh well, I suppose I'll just have to stick to the C: drive then. Thanks for you help

Jane