Hi,
I'm connecting a database to the web through ASP. I use Access to set up the database and then ADO code in my ASP.
I haven't had any problems until...
I actually have 2 databases and I used Access and Linked a Table from one to the other. I have these Joined in a Query and I'm using the Query in my ASP...however it doesn't work because the Link apparently references my mapped-drive. I even put the 2 databases in the same folder on the web server but it still doesn't work.
Is there a way to fix this? Or...if Linking is something only in Access...then is there some other approach I should take? I have a members database and then multiple sub-members databases...I'd like to keep these separate if at all possible, thinking that that's better...but maybe I'm wrong there too.

Thanks for any insight.
--Dan