<!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] Broken References in Runtime AXP</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2>The final solution would make a great article (he suggested beggingly)</FONT>
<BR><FONT SIZE=2>Jim Hale</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Charlotte Foust [<A HREF="mailto:cfoust@infostatsystems.com">mailto:cfoust@infostatsystems.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 12:36 PM</FONT>
<BR><FONT SIZE=2>To: Access Developers discussion and problem solving</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Broken References in Runtime AXP</FONT>
</P>
<BR>
<P><FONT SIZE=2>Nope, sorry, but that didn't work for me in Access 2002. I found that a</FONT>
<BR><FONT SIZE=2>long time ago, but it did not result in either a fixed reference or a</FONT>
<BR><FONT SIZE=2>compiled application, although the reference "thought" it was fixed. I</FONT>
<BR><FONT SIZE=2>had to work my way through to something that would work reliably and</FONT>
<BR><FONT SIZE=2>permanently when a customer opened the application using a runtime</FONT>
<BR><FONT SIZE=2>installation. </FONT>
</P>
<P><FONT SIZE=2>Charlotte Foust</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Marcus, Scott (GEAE, Contractor) [<A HREF="mailto:scott.marcus@ae.ge.com">mailto:scott.marcus@ae.ge.com</A>] </FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 9:00 AM</FONT>
<BR><FONT SIZE=2>To: 'Access Developers discussion and problem solving'</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Broken References in Runtime AXP</FONT>
</P>
<BR>
<P><FONT SIZE=2>Charlotte,</FONT>
</P>
<P><FONT SIZE=2>I know that I'm jumping in the middle here but...</FONT>
</P>
<P><FONT SIZE=2>Your solution is in the Microsoft knowledge base. The article is 194374.</FONT>
<BR><FONT SIZE=2>I have used this method for years. It works very well</FONT>
</P>
<P><FONT SIZE=2>Here is a link to the article:</FONT>
<BR><FONT SIZE=2><A HREF="http://support.microsoft.com/default.aspx?scid=kb;en-us;194374" TARGET="_blank">http://support.microsoft.com/default.aspx?scid=kb;en-us;194374</A></FONT>
</P>
<P><FONT SIZE=2>Scott</FONT>
</P>
<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Charlotte Foust [<A HREF="mailto:cfoust@infostatsystems.com">mailto:cfoust@infostatsystems.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, July 23, 2003 12:01 PM</FONT>
<BR><FONT SIZE=2>To: Access Developers discussion and problem solving</FONT>
<BR><FONT SIZE=2>Subject: RE: [AccessD] Broken References in Runtime AXP</FONT>
</P>
<BR>
<P><FONT SIZE=2>OK, here's the situation as it stands. Using a query, as Gustav</FONT>
<BR><FONT SIZE=2>suggested, seems to give me an accurate way to test for a broken</FONT>
<BR><FONT SIZE=2>reference. I call that test from my FixReference routine and if it's</FONT>
<BR><FONT SIZE=2>true, I repair the library reference by removing it add adding it back.</FONT>
<BR><FONT SIZE=2>RefLibPaths gives me the correct path for adding it back, so that part</FONT>
<BR><FONT SIZE=2>is easy. This works in runtime or full installation and only performs</FONT>
<BR><FONT SIZE=2>the fix if the reference is actually broken. </FONT>
</P>
<P><FONT SIZE=2>The compile issue is a bit trickier and I found a kludge, but I'm open</FONT>
<BR><FONT SIZE=2>to suggestions if anyone has them. The undocumented SysCmd(504, 16483)</FONT>
<BR><FONT SIZE=2>doesn't error but it doesn't seem to compile either. I ran into a post</FONT>
<BR><FONT SIZE=2>on the net that suggested it might not work with modules open (didn't</FONT>
<BR><FONT SIZE=2>say how you ran code otherwise, but I assume the reference was to the 97</FONT>
<BR><FONT SIZE=2>VBE) so I started thinking "macro". If found that if I modify my</FONT>
<BR><FONT SIZE=2>autoexec macro, it will run the compile for me. So an autoexec that</FONT>
<BR><FONT SIZE=2>looks like this compiles the app after fixing the reference:</FONT>
</P>
<P><FONT SIZE=2>Condition Action Command</FONT>
<BR><FONT SIZE=2>IIf(FixReference()=True,True,False)</FONT>
<BR><FONT SIZE=2>... RunCommand</FONT>
<BR><FONT SIZE=2>CompileAndSaveAllModules</FONT>
<BR> <FONT SIZE=2>OpenForm</FONT>
<BR><FONT SIZE=2>frmSplash</FONT>
</P>
<P><FONT SIZE=2>Charlotte Foust</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>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>