I have a client that has access backend for his cf application, when trying to run a query for a report that checks for item status the page always times out never will load. The query works on other reports with no problem. There are about 1500 products in the field and the status id is numerical from 1-10.
Now myself personally I would never use an access database for this type of work I would prefer to use mysql but I don't have that choice. So if anyone is familiar with cf/access or know of any issues that have to do with access indexing not working correctly under a cf app please let know. Web Your Business Inc., - located in Loveland, Colorado; serving the World! http://www.webyourbusiness.com/ - & - http://www.aaabusinesshosting.com/ Phone: 970-593-6260 - Fax: 970-593-6267 - Toll Free: 1-877-416-8655 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:185556 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
