I have an access database containing multiple tables, queries and an ODBC linked table to a dos multivalue database system. I am running a query on this linked table which runs perfectly when you run the mdb from the desktop. The problem is that when you try to run it from an aspdb(enterprise) webpage it gives the following error

Error # (Get_RS_GetCount - 1 -SELECT COUNT(*) as c from qstock) = 80004005(-2147467259)
Description = [Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'BM' failed.
Source = Microsoft OLE DB Provider for ODBC Drivers
SQL State = S1000
Native Error = -2001

where BM is the system DSN for the multivalue database.

The ODBC is a read only driver and the connection is username & pwd protected.
What am I doing wrong?
I hope we can make this work.
Regs
Tony