[AccessD] HELP Very odd problem (to me anyhow)

The problem is usually caused by having A2k with lower than SR-3
installed and having any of the XP apps installed on the same machine.
The VBE6.DLL installed by OXP breaks the A2k implementation.  MS used to
have a hotfix available until they rolled it up in to SR-3.  Unless
you're violently opposed to the security patches in SR-3, that's the
simplest way to avoid this issue.

Charlotte Foust

-----Original Message-----
From: John Clark [mailto:John.Clark at niagaracounty.com] 
Sent: Friday, June 20, 2003 10:39 AM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] HELP Very odd problem (to me anyhow)


To add on to my own post...

When I finished writing this Email, I created a new form from scratch,
and cut & pasted all controls from the old form to the new one. This new
form worked fine, but of course none of the code is there either, so I
went back to the old form to cut out the code...I was going to do this
piece by piece, hoping to find the snag...but, when I attempt to go to
the code window, I get the afore mentioned error, and although it lets
me into the coding section, no code seems to exist.

>>> John.Clark at niagaracounty.com 06/20/03 01:57PM >>>
I haven't bugged any of ya in quite a while now...about two months plus.
I have actually been away from 
Access and instead, learning the fine art of IP phones, and wireless
networking.  Now I am back into Access and having a major problem.

I am working on a program that I was probably 90% done with, when I was
pulled off for the other project. And, when I press certain buttons, I
was receiving errors that, "...Network connection my have been lost." 
I
first thought it was no big deal...the program, because of my other
duties, has run so far behind, that I will just delete the offending
buttons and recreate them...but then grew more concerned, when I
received this error, while trying to comment out the code behind the
buttons. I decided, because of time constraints, that it would be best
to create a totally new program and import the pieces into it. This
isn't working either. 

I have only inported the tables, queries, and three very simple
forms...these are just "switchboard" type forms...that, using buttons,
call other forms or each other. I reuse these same forms for each
program that I do, so that all programs in the county have a similar
look and feel to them. I have done this a few times now, and each time
they work, until I restart the program. I then get the following error,
when I attempt to open the form: 

<ERROR START>
The expression On Open you entered as the event property setting
produced the following error: Error accessing file. Network connection
may have been lost.

* The expression may not result in the name of a macro, the name of a
user-defined function, or [Event Procedure].
* There may have been an error evaluating the function, event, or macro.
<ERROR END>

There doesn't appear to be any code there, when I look. And, equally
puzzling, is that I am not using it on the network. I created it on my
hard drive, and I am running it from there now.

Anybody seen anything like this before?

Thanks!



John W. Clark
Computer Programmer / Asst. Network Administrator
Niagara County
Central Data Processing _______________________________________________
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