ggrrr....
I have an an Excel VBA application, which pulls data from an Access database. I want everyone in the company to use the same database, but there is no mapped server space that is universally available. However, there is a company-wide intranet, so I decided to try hosting it there.
The intranet department is taking forever to set this up for me... I wanted to test my code, so I tried FTPing my mdb file to some un-unprotected space on a friends website. I tried calling it with this code:
[vba]Set CNN = New ADODB.Connection
CNN.Open "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=//WebSiteName.org/testdb/TestDB2.mdb"[/vba]
This sits there for a while, and comes back with an error:
If I substitute a local copy, the code works fine.-2147467259
'\\WebSiteName.org\testdb\TestDB2.mdb' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides.
[vba]CNN.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\TestDB2.mdb"[/vba]
Am I missing something basic here? Do I have to change the connection string to go out over the web?
Any advice is appreciated.