I cant find this in the FAQ's.<BR><BR>I'm using ASP and I have TWO separate .mdb databases in the same directory of a folder on a web server. Yes, they HAVE to be separate databases.<BR><BR>I need to form a query based on tables from BOTH of these databases. <BR><BR>In Microsoft Access, it's quite easy to create a link table in one of the databses and then create the query that I desire, however I cannot do this with ASP. <BR><BR>Can anyone provide an EXAMPLE of the actual ASP code required to accomplish this task?<BR><BR>Background info: I created a link table in access and uploaded the database to the web to try it that way, but the problem was that the path that it saved to the link table was a path to my hard drive (I.E C:\Documents and settings....etc), So naturally the server produces a message saying that the link table that I am reffering to can not be found. I CANNOT change the path in access - it just has no where to do this. Can the path to the link table be changed in access or in any other software maybe or is this method incorrect?