[AccessD] 'Find' inconsistent

I wasn't very clear in my inquiry.

I remember an issue a couple of years ago with opening a table, clicking
find and entering a value, and a totally different record is found.

I also remember that we installed a service pack and the issue was
resolved.

The only problem is I can't remember what service pack we used.

A client of ours just installed Access2000 (without service packs), and
they are running into this problem.

 

Sorry about the confusion,

Mark

 

-----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com] 
Sent: Wednesday, February 19, 2003 5:01 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] 'Find' inconsistent

 

A filter will handle complex expressions -- no need to do one and then
the other -- just do them all with the filter. ADO Find can't handle And
and Or. 

 

Susan H. 

	----- Original Message ----- 

	From: Arthur Fuller <mailto:artful at rogers.com>  

	To: accessd at databaseadvisors.com 

	Sent: Wednesday, February 19, 2003 4:35 PM

	Subject: RE: [AccessD] 'Find' inconsistent

	 

	I have used it extensively without problems. Perhaps you are
referring to inconsistencies between DAO's many FIND commands and ADO's
single command? For example, you can't find on a complex expression. You
have to find on one expression then filter the result set on the rest of
the expression. At least that's the only thing that worked for me. 

	 

	-----Original Message-----
	From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com] On Behalf Of Mark Boyd
	Sent: February 19, 2003 3:23 PM
	To: AccessD at databaseadvisors.com
	Subject: [AccessD] 'Find' inconsistent

	 

	I'm using Access2000, and am having a problem finding records
when using the 'Find' command.

	I remember reading somewhere about an inconsistency with finding
the correct records.

	Is there a service pack that resolves this issue (Access, Jet,
MDAC)?

	Any help is greatly appreciated

	 

	Thanks,

	Mark Boyd

	Sr. Systems Analyst

	McBee Associates, Inc.

	 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030219/72808109/attachment-0002.html>