Yes, Access will support that. ============================ http://cfhub.com/forum/index.cfm?FuseAction=Thread&TopicID=1914&Start=Last
Datasource1=iether of your valid datasources t2 *the path to the second "database" *be sure to add the table name as "SecondDBTable" *SecondDbase is the filename of the second database <cfquery datasource="DataSource1" name="myQuery"> SELECT t1.id, t1.Uname, t2.email FROM members t1, C:\YourPath\SecondDbase.mdb.SecondDBTable t2 WHERE t1.Uname = t2.UserName </cfquery> <cfoutput query="MyQuery"> #Uname# #Email# <br> </cfoutput> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists