[AccessD] Yet Another Access 2007 & Win 7 Bug -- Nasty

Jim,
  Keep in mind that this is an complex mdb(e) in Access 2007. If your app.
is the same, I can pretty much guaranty you will have problems. With all the
problems that I have and had, I just don't see how it's possible you won't
have some strange stuff happen if installed in Windows 7..

  I'm still dealing with absolutely bizarre issues that have absolutely no
foreseeable solution using this (combination (mdb(e) + Access  2007 on
Windows 7)

 For example:
  Something like     Set ctrCalendar = New clsCalendar  will intermittently
fail with error "Error: 5 Invalid procedure call or argument"
  
I have never had an error report dispatched for this, and It's only on
Window 7 OS's..  Unfortunately there is no fixing this, as it appears to
simply be a breakdown in Access on Windows 7 for some reason.. 


All these stupid errors have pushed my development so far back now I'm
really struggling to convert this app to a native access 2007 format, which
I'm really hoping solves these crazy problems.

A warning to everyone.. if you're like me and have a large complex mdb(e)
application running in the A07 "Engine", DON'T "allow" it to be installed on
any Windows 7 system, you will regret it like I have... :-(


WBR
Robert






-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
Sent: Friday, March 19, 2010 7:54 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Yet Another Access 2007 & Win 7 Bug -- Nasty

Hi Robert:

Ouch, but I am glad to see you resolved that error.

I will be migrating an Access2003 application to Access2007 and you are not
making me feel very confident. 

Jim



-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Robert
Sent: Friday, March 19, 2010 6:10 AM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] Yet Another Access 2007 & Win 7 Bug -- Nasty

Been dealing with yet another program bug after switching the same program
that ran fine on Win XP to Window 7. I was getting this error on 2 different
section of the program. (There may be others but we have not found them
yet.)

Design:
 Form / Sub form design. Sub form based on simple query with 4 tables. 3
query based functions. Sub form OnCurrent event sunk to re-query some list
boxes on main form. (Error persist when removing the OnCurrent event)

   Imbedded Query Function Example:
       GetOnOrderAmount([tblInventory.InventoryID],[Location])

Symptoms:
  Intermittently; when a user moves from one record to the next 2 things
would / could happen.
	1) Throws 2 different errors (2465, 2424) and even though there is
error handling in place it would crash Access
	2) After trapping (and throwing a DoEvent after the error) for the
specific error(s), I could prevent Access from crashing. 
		a) when the error would occur; the field that had the prev.
focus would change to "#Name?" 
		   and lock up the entire database unless the user would
click back on that exact record.
		b) I could cause the error by moving between records
rapidly. I could always reproduce the error in just a few
		   seconds of doing this.
		c) Users said it was more likely to happen if using the
record selector for moving between records.

Pictures of what that looked like.
http://i40.tinypic.com/n6ztcl.png

http://i44.tinypic.com/2929mx1.png


Corrective Measures.
  After much trial and error, I discovered that if I completely remove **
ALL ** the imbedded functions in the query(s) 
  and move them to the actual sub form field(s) the problem completely went
away.. 

   =GetOnOrderAmount([tblInventory.InventoryID],[Location])

Just thought I would add to the continuing saga of Access 2007 and Windows
7.. I can say this with confidence. This is a lethal combination for anyone
utilizing an Access .mdb(e) as a front end program. 

If your program has ANY complexity to it, I can pretty much guarantee you
will encounter some of the strangest errors and anomalies you have ever
experienced with Access before... ;-)  Garbage is what it really is, utter
garbage....


WBR
Robert


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com