[AccessD] Observations of my short life with Windows 7 & Access .MDE

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


























More information about the AccessD mailing list