Problem with client side active x accessing access database on web server

Hi All,

Hope you can help / point me in the right direction with a little problem.

I have a VB6 created active X dll which is downloaded to the client using
so that I can control / use MS Word to create letters
using data extracted from an Access database which resides on a webserver.

The problem I am having is that I cannot connect to the access database on
the web server.

In the active x I have added a reference to a DLL (also written in VB6 which
my ASP pages use to get data with no problems) but the Active X fails as it
cannot find the database as it is looking for an "E
drive\folder\folder\database." which is hardcoded as part of the connection
string in the DLL and isn't a valid path on the client PC but is on the web
server.

So my question is this - how can I get a client side active x to look at an
access database sat on a web server or am I going about this in completely
the wrong way?

I am using classic ASP and VB6.

Any pointers / code examples would be appreciated.

Thanks

Roger