<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META content="MSHTML 6.00.2800.1170" name=GENERATOR>
<STYLE>@font-face {
font-family: SimSun;
}
@font-face {
font-family: @SimSun;
}
@page Section1 {size: 595.45pt 841.7pt; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
LI.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
DIV.MsoNormal {
FONT-SIZE: 11pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: Arial
}
A:link {
COLOR: blue; TEXT-DECORATION: underline
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline
}
P.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
LI.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
DIV.MsoAutoSig {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman"
}
SPAN.EmailStyle17 {
COLOR: windowtext; FONT-FAMILY: Arial
}
DIV.Section1 {
page: Section1
}
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=720322212-30052003><FONT face=Arial color=#0000ff
size=2>Ray,</FONT></SPAN></DIV>
<DIV><SPAN class=720322212-30052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=720322212-30052003><FONT face=Arial color=#0000ff size=2>
As <SPAN class=234402323-29052003><FONT face="Comic Sans MS" color=#0000ff
size=2>Charlotte said, it's a broken reference. However in some cases,
they may not be listed as "missing" or "broken". If that is the case, open
up tools/references, check any reference that is not checked, then close the MDB
and Access. Reopen Access and the MDB and uncheck the reference you
just checked. This forces Access to refresh the reference
information. Do a compile save all and everything should be
OK.</FONT></SPAN></FONT></SPAN></DIV>
<DIV><FONT size=2></FONT> </DIV>
<DIV><FONT size=2>Jim Dettman<BR>President,<BR>Online Computer Services of WNY,
Inc.<BR>(315) 699-3443<BR>jimdettman@earthlink.net </FONT></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<B>On Behalf Of </B>Ray
Li<BR><B>Sent:</B> Thursday, May 29, 2003 7:17 PM<BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Failure to open
database file<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Arial size=2><SPAN lang=EN-GB
style="FONT-SIZE: 11pt">When I open a database on a pc running Access 97, the
following errors message came out and<BR>failed in opening.<BR><BR>Function
isn't available in expressions in query expression '........<BR><BR>The report
name 'rptScoreOfAllFactories' you entered is misspelled or refers<BR>to a
report that isn't open or doesn't exist.<BR><BR>The program opened correctly
in the past but suddenly it happened today. Same<BR>program opens correctly on
other pcs. Can someone encountered similar problem before<BR>share with your
fixes to
me.<BR><BR>Thanks,<BR><BR>Ray</SPAN></FONT></P></DIV></BLOCKQUOTE></BODY></HTML>