[AccessD] Failure to open database file

I believe Jim meant that you should check any ONE of the unchecked
references, not all of them. <VBG>
 
Charlotte Foust

	-----Original Message-----
	From: Don Elliker [mailto:delliker at hotmail.com] 
	Sent: Friday, May 30, 2003 6: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/20030530/6bc657e3/attachment-0001.html>