<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.45">
<TITLE>RE: [AccessD] ? Network Connection Lost?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>When I've had similar strangeness happen I've copied the objects to a new container and recompiled. The problem has gone away. For reasons I can't explain it seems that old versions of the code are sometimes executed. This tends to happen when I've done a lot of changing and saving. I know this isn't an explanation of what is happening but in the spirit of misery loving company at least I can tell you that you are not alone.</FONT></P>
<P><FONT SIZE=2>Jim Hale </FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Kathryn Bassett [<A HREF="mailto:kathryn@bassett.net">mailto:kathryn@bassett.net</A>]</FONT>
<BR><FONT SIZE=2>Sent: Monday, April 28, 2003 9:00 PM</FONT>
<BR><FONT SIZE=2>To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] ? Network Connection Lost?</FONT>
</P>
<BR>
<P><FONT SIZE=2>I've installed SR-3 and rebooted. Then opened my mdb, and tried to run the (previously duplicated) report. I see a flash of it starting, then I see the error "Error accessing file. Network Connection may have been lost." Just above the task bar I see the information "Formatting page, press Control+Break to stop.</FONT></P>
<P><FONT SIZE=2>When I click on OK, it opens the code and shows me:</FONT>
<BR><FONT SIZE=2>Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)</FONT>
<BR><FONT SIZE=2>Image6.Picture = photo</FONT>
<BR><FONT SIZE=2>End Sub</FONT>
</P>
<P><FONT SIZE=2>However, it is supposed to be Image5 not 6. If I view code from the report, it properly says Image5. So, what's going on?</FONT></P>
<P><FONT SIZE=2>--</FONT>
<BR><FONT SIZE=2>Kathryn Bassett (Pasadena CA)</FONT>
<BR><FONT SIZE=2><A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A> </FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo</A></FONT>
<BR><FONT SIZE=2>kathryn@bassett.net * <A HREF="http://bassett.net" TARGET="_blank">http://bassett.net</A> </FONT>
</P>
<P><FONT SIZE=2>> -----Original Message-----</FONT>
<BR><FONT SIZE=2>> From: accessd-bounces@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> [<A HREF="mailto:accessd-bounces@databaseadvisors.com">mailto:accessd-bounces@databaseadvisors.com</A>]On Behalf Of Kathryn</FONT>
<BR><FONT SIZE=2>> Bassett</FONT>
<BR><FONT SIZE=2>> Sent: 28 Apr 2003 5:45:PM</FONT>
<BR><FONT SIZE=2>> To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> Subject: RE: [AccessD] ? Network Connection Lost?</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> Windows 2000 and Office 2000 - no XP. SR-1 so I'll have to find how to get SR-3. </FONT>
<BR><FONT SIZE=2>> Thought all that kind of thing was updating with the OS updates I've been doing. </FONT>
<BR><FONT SIZE=2>> Guess not. I'll keep you posted.</FONT>
<BR><FONT SIZE=2>> Kathryn</FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> > -----Original Message-----</FONT>
<BR><FONT SIZE=2>> > From: accessd-bounces@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> > [<A HREF="mailto:accessd-bounces@databaseadvisors.com">mailto:accessd-bounces@databaseadvisors.com</A>]On Behalf Of Charlotte</FONT>
<BR><FONT SIZE=2>> > Foust</FONT>
<BR><FONT SIZE=2>> > Sent: 28 Apr 2003 4:25:PM</FONT>
<BR><FONT SIZE=2>> > To: accessd@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> > Subject: RE: [AccessD] ? Network Connection Lost?</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > Are you using Access 2000? There was a conflict between the Access 2000</FONT>
<BR><FONT SIZE=2>> > version of vbe6.dll and the XP version installed with any of the 2002</FONT>
<BR><FONT SIZE=2>> > components, including things like Visio 2002. The XP version caused</FONT>
<BR><FONT SIZE=2>> > problems with 2000 code containers and could toast a database. O2K SR-3</FONT>
<BR><FONT SIZE=2>> > is supposed to have contained the patch for that problem and there are</FONT>
<BR><FONT SIZE=2>> > knowledgebase articles on it as well as previous discussions in the</FONT>
<BR><FONT SIZE=2>> > archives (assuming Drew hasn't burnt down again! <VBG>).</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > Charlotte Foust</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > -----Original Message-----</FONT>
<BR><FONT SIZE=2>> > From: Kathryn Bassett [<A HREF="mailto:kathryn@bassett.net">mailto:kathryn@bassett.net</A>] </FONT>
<BR><FONT SIZE=2>> > Sent: Monday, April 28, 2003 3:15 PM</FONT>
<BR><FONT SIZE=2>> > To: dbAdvisors (AccessD)</FONT>
<BR><FONT SIZE=2>> > Subject: [AccessD] ? Network Connection Lost?</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > I have a report (prints labels with pictures) that works fine. I did a</FONT>
<BR><FONT SIZE=2>> > copy/paste of the report so that I have a duplicate of it with a new</FONT>
<BR><FONT SIZE=2>> > name (will be slightly modifying that one). The original still will do</FONT>
<BR><FONT SIZE=2>> > the print preview, but the new one doesn't. I've tried a couple things,</FONT>
<BR><FONT SIZE=2>> > and one of them elicited an error that included phraseology of "the</FONT>
<BR><FONT SIZE=2>> > expression OnFormat ... error accessing file, Network Connection may</FONT>
<BR><FONT SIZE=2>> > have been lost"</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > This is a laptop with no network connection. What's going on, and why</FONT>
<BR><FONT SIZE=2>> > won't it do the print preview.</FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > --</FONT>
<BR><FONT SIZE=2>> > Kathryn Bassett (Pasadena CA)</FONT>
<BR><FONT SIZE=2>> > <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A> </FONT>
<BR><FONT SIZE=2>> > <A HREF="http://databaseadvisors.com/mailman/listinfo" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo</A></FONT>
<BR><FONT SIZE=2>> > kathryn@bassett.net * <A HREF="http://bassett.net" TARGET="_blank">http://bassett.net</A> </FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> > _______________________________________________</FONT>
<BR><FONT SIZE=2>> > AccessD mailing list</FONT>
<BR><FONT SIZE=2>> > AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> > <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> > Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>> > _______________________________________________</FONT>
<BR><FONT SIZE=2>> > AccessD mailing list</FONT>
<BR><FONT SIZE=2>> > AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> > <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> > Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>> > </FONT>
<BR><FONT SIZE=2>> </FONT>
<BR><FONT SIZE=2>> _______________________________________________</FONT>
<BR><FONT SIZE=2>> AccessD mailing list</FONT>
<BR><FONT SIZE=2>> AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2>> <A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>> Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
<BR><FONT SIZE=2>> </FONT>
</P>
<P><FONT SIZE=2>_______________________________________________</FONT>
<BR><FONT SIZE=2>AccessD mailing list</FONT>
<BR><FONT SIZE=2>AccessD@databaseadvisors.com</FONT>
<BR><FONT SIZE=2><A HREF="http://databaseadvisors.com/mailman/listinfo/accessd" TARGET="_blank">http://databaseadvisors.com/mailman/listinfo/accessd</A></FONT>
<BR><FONT SIZE=2>Website: <A HREF="http://www.databaseadvisors.com" TARGET="_blank">http://www.databaseadvisors.com</A></FONT>
</P>
</BODY>
</HTML>