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: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of John Viescas Sent: Thursday, 22 December 2005 12:20 AM To: [email protected] 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 Sponsor --------------------~--> AIDS in India: A "lurking bomb." Click and help stop AIDS now. http://us.click.yahoo.com/VpTY2A/lzNLAA/yQLSAA/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/
