[AccessD] Bug Report

John:

At that level of form complexity could you be bumping up against any of the 
(undocumented) Access limitations that the SQL and Oracle folks are always 
ragging us about?

Rocky

----- Original Message ----- 
From: "John W. Colby" <jwcolby at colbyconsulting.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Monday, August 15, 2005 9:29 AM
Subject: RE: [AccessD] Bug Report


> Rocky,
>
> This is indeed fascinating.  I am at a loss on this one.  I am no
> lightweight at this stuff and I just can't figure it out.  I know that the
> Windows98 users do not have the problem, the Win2K users do see it but
> rarely, the WinXP users see it occasionally, and apparently more often 
> with
> SP3.  So is it an Access bug or a Windows bug?
>
> In this specific case (the only place I am seeing it), it is in the OnOpen
> of this one specific form.  The form is a bound form, VERY complex, with
> probably 50-100 controls.  18 tabs using JIT subforms to only load the
> subforms if the tabs are clicked.
>
> The form has a clsForm that ties the form into my framework.  That class
> passes a pointer to the form into the class and the class then iterates 
> the
> form for every control, loading a withevents class for each control found.
> I have however commented out that specific class such that the framework 
> is
> not triggered for the form and the problem still exists.
>
> In addition to that class, I also have 9 other classes loading, mostly
> classes that are passed in controls and enforce rules regarding sets of
> controls.  I have not yet dimmed out those classes to see if the issue 
> goes
> away.
>
> And yes, it also occurs on my laptop where the FE/BE are both on the same
> machine.  HOWEVER, the BE (and FE for that matter) resides on a mapped
> (mounted) drive.  On my laptop I use an encryption program to set up a big
> file which is "turned into a drive".  IOW, this file is mounted as a drive
> by a driver.  The driver asks for a password before mounting the "drive". 
> I
> do this so that I can carry sensitive customer data on my machine without
> exposing the data if the laptop is lost or stolen.  Furthermore I can just
> backup the source file that is a drive, to backup the entire development
> drive.
>
> These drives are mounted as drive K, M and X.  Does that count as a 
> network
> drive?  The driver performs the mounting at specific drive letters.
>
> Anyway, it is not AFAIK going out over the network, so I do not think it 
> is
> a NIC problem.
>
> This is NOT going to be easy for them to troubleshoot.  The BE is now
> approaching 400 mbytes and contains sensitive personal and medical data on
> tens of thousands of people.  I am guessing that if they are going to do 
> it
> at all they will have to remote in to my laptop at my office and work on 
> it
> remotely.  It should be interesting to see what happens.
>
> Just in...  I got this email this morning:
>
> CASE_ID_NUM: SRZ050815000001
> MESSAGE:
> ********************** The message for you follows 
> ************************
> Hi John,
>
>          Thank you for using Microsoft Online Assisted Support.  In order
> to route your case to a Support Professional we will need to re-entitle 
> your
> case. The product ID that you supplied indicates that your software came
> part of an Open License Agreement. This is a special license agreement tha 
> t
> your company purchased so they could obtain many copies of the software at 
> a
> significant cost savings. This allows your company to save money by
> purchasing the software in volume.  However, the software does not come 
> with
> any free technical support.  If you would like to have a support 
> profession
> al troubleshoot your issue, we must process a retail PID for Office
> (w/Access), an access ID identifying a pre-paid support account, or a 
> credit
> card charge ($99 over the web, $245 over the phone).
>
> IOW, the action pack does not get free support incidents.  Sigh.
>
> John W. Colby
> www.ColbyConsulting.com
>
> Contribute your unused CPU cycles to a good cause:
> http://folding.stanford.edu/
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Monday, August 15, 2005 11:37 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Bug Report
>
>
> Interesting.  What's your speculation on where it's happening?  In the
> interpretation of your classes?  They obviously have no clue and cannot
> track it down without getting your app and running it themselves.  At 
> first
> it behaves like a bad NIC - I've had apps go south with corruptions and
> shutdowns and traced it to a cheap NIC on the network - but you're running
> this standalone, yes?
>
> Rocky
>
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>