ASP & Access Db - linked tables

[infopimp]

hi There,

New to ASP, I'm trying to display records from an access qry which
takes data from several tables two of which are linked.

The db which is the source of my qry is on my web server (using IIS),
but the linked tables are on a separate file server on the same
network. However I keep getting an error stating that the db which
contains the linked tables cannot be found. I didn't realise this
would be a problem, thinking that as long as the db on the web server
had OLE data access file pointing to it then all would run smoothly.

Could anyone suggest a method which would allow the browser/web app to
locate this db without me having to migrate it to the same web server
or reconfiguring the file server.
I hope this make sense (it does in my head......somehow)

thanks
ip ;-)

[David Schofield]

On 4 Oct 2004 13:02:04 -0700, [e-mail] (infopimp) wrote:

hi There,

New to ASP, I'm trying to display records from an access qry which
takes data from several tables two of which are linked.

The db which is the source of my qry is on my web server (using IIS),
but the linked tables are on a separate file server on the same
network. However I keep getting an error stating that the db which
contains the linked tables cannot be found. I didn't realise this
would be a problem, thinking that as long as the db on the web server
had OLE data access file pointing to it then all would run smoothly.

Could anyone suggest a method which would allow the browser/web app to
locate this db without me having to migrate it to the same web server
or reconfiguring the file server.
I hope this make sense (it does in my head......somehow)

thanks
ip ;-)

Hi
I can't answer your query but I would avoid running queries which make
joins across a network, unless the tables involved are small.
David