[AccessD] Bug Report

John W. Colby jwcolby at colbyconsulting.com
Mon Aug 15 11:29:26 CDT 2005


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





More information about the AccessD mailing list