Thank you Dean for seeing my issue, and supplying a possible resolution. I agree access is not the best system out there, But I have applications with over 500,000 records in a single table that have been working with cold fusion of many years also. I agree I should migrate but that is not in my scope for this project right now. I will try that solution today and let you know.
Thank You, Keith ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:314392 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4