Robert
robert at servicexp.com
Thu Jan 21 08:35:06 CST 2010
Observations of my short life with Windows 7 (32 bit) & Access .MDE (Access 2007 Runtime) Comparing the above against a tried & true Access Program (Same as installed on Windows 7) In Windows XP 1) Performance: Much Worse Wow, what can I say. Just about every aspect of performance has dropped. Read / Write times have dropped, Query performance has dropped. I Think there must be some OS mechanics that has changed as it related to MS Acess, and has somehow effected performance. (Still Looking for Answers) 2) Stability: Much Worse In the last 10 years, I have never had a user with a corrupted FE until yesterday. Somehow the front end corrupted and every time ONE list box was requeried they would get this msg. (after the Error Access Would Crash)(replacing the FE Fixed the problem) "Error#: -2147417848; Sys Desc: Method 'Requery' of object '_ListBox' failed" Now, for some reason, the MS Access.exe is not always closing or closing fast enough and Windows 7 doesn't like it and wants' to send a message and restart the program. I now have reports of what I call "Hanging Chads" under process. (The MS Access.exe did not close) I have combed over thousands of lines of code in the last 4 days looking for any objects that are not getting destroyed, and I simply can't find any, but yet my program engine (Access) is not always closing under Windows 7. (No problems in Windows XP) Complaints of random complete crashes, which of course there seems to be no pattern too. I currently have about 11 Windows 7 beta testers, and over 350 long term seated Windows XP installation. So the data pool is not huge, but something seems to be going on here... Keep in mind, with the exception of the installer (I'm trying to use Saykey's Access 2007 Development Wizard (Thats another topic in and of itself)) which is based on the MSI engine) and the OS (Win 7), the program is identical to ones being installed on Windows XP machines (Wise and Sagkey Scripts for those) PS: Has anyone else notice the "Bug" with the MSI installer? With windows Vista and Window 7, MS added the great ability to redirect users shell folders. It's a fantastic "feature" however it completely break the entire MSI Installing engine.. I would love to know if this is a bug or an intended MS feature....? Anyway RANT OFF WBR Robert