Guy- Won't work. I believe that when you try to execute a saved query via ASP, the query SQL gets fetched, and then the SQL is attempted on the current connection. But I could be wrong.
I thought you might use the IN clause in the FROM, but unfortunately that applies to *all* the tables in the FROM clause. Are you sure it doesn't work if the Connection is correct relative to the location of the web server? John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of Guy Harley Sent: Wednesday, December 21, 2005 5:01 PM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Linked Tables ASP accesses queries in the first database and those queries need to reference linked tables in the second database (ie a table for DB1 has a join to a table in DB2). I though I might be able to write ASP code to change the table references in the database using the connection object but initial research is not looking promising. Guy Harley -----Original Message----- From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, 22 December 2005 12:20 AM To: ms_access@yahoogroups.com Subject: RE: [ms_access] Linked Tables Guy- Why do Linked Tables have to do with an ASP? All you need do is change the Connect property setting in the code of each ASP to point to where the database will be (the actual data tables, not the linked ones) on the web server. John Viescas, author "Building Microsoft Access Applications" "Microsoft Office Access 2003 Inside Out" "Running Microsoft Access 2000" "SQL Queries for Mere Mortals" http://www.viescas.com/ Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get Bzzzy! (real tools to help you find a job). Welcome to the Sweet Life. http://us.click.yahoo.com/KIlPFB/vlQLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
