<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=044335814-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2>I believe Jim meant that you should check any ONE of the unchecked
references, not all of them. <VBG></FONT></SPAN></DIV>
<DIV><SPAN class=044335814-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=044335814-30052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte Foust</FONT></SPAN></DIV>
<BLOCKQUOTE style="MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT
face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> Don Elliker
[mailto:delliker@hotmail.com] <BR><B>Sent:</B> Friday, May 30, 2003 6:46
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Failure to open database file<BR><BR></FONT></DIV>
<DIV>
<DIV>
<P>Is it really necessary to check them ALL to do this 'kick-in-the-pants"
reference repair ? Won't adding a couple do the trick, supposing that the
needed refs are there in the first place, of course.<BR>_D</P></DIV>
<DIV></DIV>
<DIV><FONT face="Geneva, Arial, Sans-serif" color=#6666ff size=2><EM>"Things
are only free to the extent that you don't pay for them." </EM></FONT></DIV>
<DIV><FONT color=#33cc66></FONT></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>
<DIV></DIV>>From: "Jim Dettman" <JIMDETTMAN@EARTHLINK.NET>
<DIV></DIV>>Reply-To: accessd@databaseadvisors.com
<DIV></DIV>>To: <ACCESSD@DATABASEADVISORS.COM>
<DIV></DIV>>Subject: RE: [AccessD] Failure to open database file
<DIV></DIV>>Date: Fri, 30 May 2003 08:29:28 -0400
<DIV></DIV>>
<DIV></DIV>>Ray,
<DIV></DIV>>
<DIV></DIV>> As Charlotte said, it's a broken reference. However in some
cases, they
<DIV></DIV>>may not be listed as "missing" or "broken". If that is the
case, open up
<DIV></DIV>>tools/references, check any reference that is not checked, then
close the
<DIV></DIV>>MDB and Access. Reopen Access and the MDB and uncheck the
reference you
<DIV></DIV>>just checked. This forces Access to refresh the reference
information. Do
<DIV></DIV>>a compile save all and everything should be OK.
<DIV></DIV>>
<DIV></DIV>>Jim Dettman
<DIV></DIV>>President,
<DIV></DIV>>Online Computer Services of WNY, Inc.
<DIV></DIV>>(315) 699-3443
<DIV></DIV>>jimdettman@earthlink.net
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Ray
Li
<DIV></DIV>> Sent: Thursday, May 29, 2003 7:17 PM
<DIV></DIV>> To: AccessD@databaseadvisors.com
<DIV></DIV>> Subject: [AccessD] Failure to open database file
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> When I open a database on a pc running Access 97, the
following errors
<DIV></DIV>>message came out and
<DIV></DIV>> failed in opening.
<DIV></DIV>>
<DIV></DIV>> Function isn't available in expressions in query expression
'........
<DIV></DIV>>
<DIV></DIV>> The report name 'rptScoreOfAllFactories' you entered is
misspelled or
<DIV></DIV>>refers
<DIV></DIV>> to a report that isn't open or doesn't exist.
<DIV></DIV>>
<DIV></DIV>> The program opened correctly in the past but suddenly it
happened today.
<DIV></DIV>>Same
<DIV></DIV>> program opens correctly on other pcs. Can someone encountered
similar
<DIV></DIV>>problem before
<DIV></DIV>> share with your fixes to me.
<DIV></DIV>>
<DIV></DIV>> Thanks,
<DIV></DIV>>
<DIV></DIV>> Ray
<DIV></DIV>>_______________________________________________
<DIV></DIV>>AccessD mailing list
<DIV></DIV>>AccessD@databaseadvisors.com
<DIV></DIV>>http://databaseadvisors.com/mailman/listinfo/accessd
<DIV></DIV>>Website: http://www.databaseadvisors.com
<DIV></DIV></DIV><BR clear=all>
<HR>
Add photos to your e-mail with <A
href="http://g.msn.com/8HMDENUS/2746??PS=">MSN 8.</A> Get 2 months FREE*.
</BLOCKQUOTE></BODY></HTML>