<html><div style='background-color:'><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*.</html>