Correct path to mdb

[Bluie]

Hello

The path to my online MS Access database 2007 and hosted by my Web hosting service is: E:\HostingSpaces\domain\domain.net\wwwroot\App_Dat a

In my vb.net code, would I write that as:

Const ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;E:\HostingSpaces \domain\domain.net\wwwroot\App_Data\students.mdb;"

At the moment, I have this:

Const ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|students.mdb;"

Many thanks



Bluie

[ranman256]

You shouldn't use drive letters. Not everyone has them mapped.
use UNC paths:
\\server\folder\folder\file.mdb

[Bluie]

I will give that a try, ranman256, and hopefully it will work. Something like this:

"Provider=Microsoft.Jet.OLEDB.4.0;\\HostingSpa ces \domain\domain.net\wwwroot\App_Data\students.mdb;"

Thanks for replying.