Jeanmarie, In Billy's example, if the Linked Server (which is a reference to the Access database) is called 'ACCESSNOTES', and if you want to make a SQL Server call to a table called 'NOTES' in that database, the FROM statement would look like this (note the extra "."s in there):
FROM ACCESSNOTES...NOTES So, this could be run from any connection to that SQL Server, and the query does not have to be in a stored proc. <cfquery datasource="mySQLServerDSN" name="getNotes"> SELECT * FROM ACCESSNOTES...NOTES </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:320397 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
