[galoochi]

I'm trying to run a VBScript that calls a Microsoft Access database. When I have the database saved locally on my computer it runs just fine. Here's what it looks like:

Dim ConnectionString
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=g:\database.mdb"
CN.Open ConnectionString

But when I have the database stored on a local network share, I get an error. The local network share shortcut is \\hp\e, so I've been trying the following:

Dim ConnectionString
ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\hp\e:\database.mdb"
CN.Open ConnectionString

But it's not working. What am I doing wrong? Thanks!!!

[BobRodes]

nothing wrong with your syntax. Perhaps e: isn't shared?

[maj3091]

Maybe it's just a typo in your post, but you refer to the share as "\\hp\e" then try to reference it in your code as "\\hp\e:"

[thava]

i think the : might be the problem remove it,

[galoochi]

BobRodes, on 15 September 2012 - 07:48 PM, said:

nothing wrong with your syntax. Perhaps e: isn't shared?

e: is definitely shared, I can open the files on it, I just can't successfully run this script Very frustrated...

Could it be a problem that I'm running Windows 7 and the HP I'm networking with is running XP?

[BobRodes]

thava, on 17 September 2012 - 01:40 AM, said:

i think the : might be the problem remove it,

No, that's the right syntax for a mapped network drive. Galoochi, please tell the exact error and which line of code causes it.

[galoochi]

thava, on 16 September 2012 - 11:40 PM, said:

i think the : might be the problem remove it,

I can't believe it, but this fixed it! I thought the colon was necessary for the network location, but I guess not. Thank you!

[BobRodes]

So did I! Thava, feel free to explain further...

[thava]

normally a shared resource can be accessed in the explorer like this

name of the shared computer is hp
then we should use like this
\\hp
name of the shared folder or shared drive is e then
\\hp\e
if it contains a database.mdb file and we need to open it
we should type like this
\\hp\e\database.mdb

but the OP has wrongly typed it in his connection string
like this
\\hp\e:\database.mdb

that's why i say just remove the : from the path
i think maj3091 also mention the same thing

This post has been edited by thava: 26 September 2012 - 02:19 AM