[AccessD] Failure to open database file

Jim Dettman jimdettman at earthlink.net
Fri May 30 10:31:16 CDT 2003


Don,

  Funny, I've been more or less stating it that way for years and never
thought anyone would check them all.  NO you you only need to do it with ONE
reference to force the reference cleanup.  Your just trying to get the list
to change.  Just as easily, you could uncheck one reference and then recheck
it.

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 Don Elliker
  Sent: Friday, May 30, 2003 10:46 AM
  To: accessd at databaseadvisors.com
  Subject: RE: [AccessD] Failure to open database file


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

  "Things are only free to the extent that you don't pay for them."
  >From: "Jim Dettman"
  >Reply-To: accessd at databaseadvisors.com
  >To:
  >Subject: RE: [AccessD] Failure to open database file
  >Date: Fri, 30 May 2003 08:29:28 -0400
  >
  >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
  >_______________________________________________
  >AccessD mailing list
  >AccessD at databaseadvisors.com
  >http://databaseadvisors.com/mailman/listinfo/accessd
  >Website: http://www.databaseadvisors.com


----------------------------------------------------------------------------
--
  Add photos to your e-mail with MSN 8. Get 2 months FREE*.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030530/ff6f3281/attachment-0001.html>


More information about the AccessD mailing list