Jim Lawrence
accessd at shaw.ca
Mon May 17 12:52:39 CDT 2010
Hi All: Has anyone else ran into the 'mid, left and right' errors? I have had this problem pop up from time to time on a variety of MS Access applications. Sometime it takes a while to actually get the system to respond with an error message but an odd display may trigger an investigation and then drilling down usually uncovers the source. Most times I have been able to code around it, sometimes it will only affect one or maybe two desktops in a whole site. It usually shows up when there is a very complex piece of code or sequel request. Sometimes the problems can be resolved by pre-processing some of the data before some heavy number crunching. Other times by recompiling on the client's site... Other times by repeatedly applying patches. I have had the same problem with Access 2000, 2003 and 2007 on Windows OS XP, Vista and Windows7 Is this just me or have others run across the same problem? Is there a resolution or a specific cause? Any comments or help would be greatly appreciated. Jim