<html><div style='background-color:'><DIV>
<P>Jim,</P>
<P>Sorry man...I just had a 'Charles' moment of total literalism *-} <BR>_d<BR></P></DIV><BR><BR><BR>
<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 11:31:16 -0400
<DIV></DIV>>
<DIV></DIV>>Don,
<DIV></DIV>>
<DIV></DIV>> Funny, I've been more or less stating it that way for years and never
<DIV></DIV>>thought anyone would check them all. NO you you only need to do it with ONE
<DIV></DIV>>reference to force the reference cleanup. Your just trying to get the list
<DIV></DIV>>to change. Just as easily, you could uncheck one reference and then recheck
<DIV></DIV>>it.
<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>>
<DIV></DIV>> -----Original Message-----
<DIV></DIV>> From: accessd-bounces@databaseadvisors.com
<DIV></DIV>>[mailto:accessd-bounces@databaseadvisors.com]On Behalf Of Don Elliker
<DIV></DIV>> Sent: Friday, May 30, 2003 10:46 AM
<DIV></DIV>> To: accessd@databaseadvisors.com
<DIV></DIV>> Subject: RE: [AccessD] Failure to open database file
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>> Is it really necessary to check them ALL to do this 'kick-in-the-pants"
<DIV></DIV>>reference repair ? Won't adding a couple do the trick, supposing that the
<DIV></DIV>>needed refs are there in the first place, of course.
<DIV></DIV>> _D
<DIV></DIV>>
<DIV></DIV>> "Things are only free to the extent that you don't pay for them."
<DIV></DIV>> >From: "Jim Dettman"
<DIV></DIV>> >Reply-To: accessd@databaseadvisors.com
<DIV></DIV>> >To:
<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></DIV>>
<DIV></DIV>>----------------------------------------------------------------------------
<DIV></DIV>>--
<DIV></DIV>> Add photos to your e-mail with MSN 8. Get 2 months FREE*.
<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/8HMCENUS/2746??PS=">MSN 8.</a> Get 2 months FREE*.</html>