[AccessD] Failure to open database file

Ray,

  As 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.

Jim Dettman
President,
Online Computer Services of WNY, Inc.
(315) 699-3443
jimdettman at earthlink.net
  -----Original Message-----
  From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Ray Li
  Sent: Thursday, May 29, 2003 7:17 PM
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Failure to open database file


  When I open a database on a pc running Access 97, the following errors
message came out and
  failed in opening.

  Function isn't available in expressions in query expression '........

  The report name 'rptScoreOfAllFactories' you entered is misspelled or
refers
  to a report that isn't open or doesn't exist.

  The program opened correctly in the past but suddenly it happened today.
Same
  program opens correctly on other pcs. Can someone encountered similar
problem before
  share with your fixes to me.

  Thanks,

  Ray
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030530/a5f0ef09/attachment-0001.html>