Ray Li
ray282828 at yahoo.com.hk
Wed Jun 4 00:52:43 CDT 2003
Thanks for all responses that are useful to me resolving the problem. I did discover a missing reference of Microsoft DAO 3.51 Object Library in references. The dll file is in the folder. I unchecked the reference and re-registered it. Thus, it works now. I have inquired the user who said no program installed recently and any crash on the pc. However, I noticed that the Windows 98 could not shut down properly and there was below error message when I clicked Properties of printer or randomly clicked any menus. Internet Explorer Script Error An error has occurred in the script on this page. Line: 53 Char: 4 Error: Library not registered. Code: 0 URL: file://C:\WINDOWS\web\printers.htt <file:///C:\WINDOWS\web\printers.htt> Do you want to continue running scripts on this page? Yes No Although I fixed up the problem, I still do not know why it happened. Is there any member to have identified the causes of this problem? Thanks, Ray Li -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Dettman Sent: Friday, 30 May, 2003 11:31 p To: accessd at databaseadvisors.com Subject: RE: [AccessD] Failure to open database file 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. <http://g.msn.com/8HMDENUS/2746??PS=> Get 2 months FREE*. -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030604/db370f92/attachment.html>