I'm not sure if this is a scripting issue or a general one.
I've got an access db - located in 'D:\Program Files\MUSHclient\worlds\'
In several alias' I open that db using vbscript embedded in the send window:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=Stores1.mdb"
And everything works fine.
BUT - from time to time I get the error:
'D:\Program Files\MUSHclient\Stores1.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.
Nothing has actually changed from my perspective - but to access the db I then have to change my data source:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=worlds\\Stores1.mdb"
and then those alias' will work again.
Then down the track they stop working with much the same error and I have to put the path back to the original.
I've found the Global Preferences|Worlds|Default world file directory setting - but as far as I can determine that doesn't seem to be changing.
What I'm trying to figure out is what is providing the [i]'D:\Program Files\MUSHclient\worlds\'[/i] in the first place, and what could be causing it to change?
I've got an access db - located in 'D:\Program Files\MUSHclient\worlds\'
In several alias' I open that db using vbscript embedded in the send window:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=Stores1.mdb"
And everything works fine.
BUT - from time to time I get the error:
'D:\Program Files\MUSHclient\Stores1.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.
Nothing has actually changed from my perspective - but to access the db I then have to change my data source:
Set db = CreateObject ("ADODB.Connection")
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=worlds\\Stores1.mdb"
and then those alias' will work again.
Then down the track they stop working with much the same error and I have to put the path back to the original.
I've found the Global Preferences|Worlds|Default world file directory setting - but as far as I can determine that doesn't seem to be changing.
What I'm trying to figure out is what is providing the [i]'D:\Program Files\MUSHclient\worlds\'[/i] in the first place, and what could be causing it to change?