Hi everybody,
Really perplexing problem at the moment. A colleage interstate has
developed
a database and corresponding data access page which works fine for them.
We've been sent it locally and I've been asked to set it up here. The
problem
is, it only works if I open the HTA file from a mapped drive S:\
If I open it from a mapped drive G:\ or N:\ (where it will be used) it
doesn't grab any data. Even weirder, if I open the HTA for editing, it
can't
connect to the MDB if I open it from any location apart from S:\.
For the record, the database connection string doesn't refer to a mapped
drive, it uses \\sadlfs004\deptdata\shared\productivity\productivity
sa\exgratia.mdb I've gone through every inch of the Script Editor,
looking
for a reference to S:\ and I can't see anything.
Does anybody know what might cause a data access page to only connect to
it's host data by a specific mapped drive? Any ideas how I might solve
this?
Cheers,
Bob
|
