[AccessD] A Mystery

Two  things to  look for:

Most likely: Null entries in a sorted/filtered field or one of the source fields of a calculated 
column.

Secondly: If you are using any functions in your query, check for missing/broken references.

-- 
Stuart

On 22 Aug 2011 at 18:35, Rocky Smolin wrote:

> Dear List:
> 
> I have a client I helped with a legacy app - interesting business -
> seed dealer - buys some and grows some on land in El Centro.  But I
> digress.
> 
> I got a call today from the company - they're getting an error on
> opening the mdb - "Data type mismatch in criteria expression".  The
> opening form has as a Record Source a query that does indeed generate
> that error when I run it. 
> 
> So my first thought is that their network has corrupted the back end. 
> They sent me the back end and I can duplicate the error but there are
> not apparent corrupted records.  
> 
> I isolated the field in the query that causes the error but everything
> looks dandy with that field.
> 
> I set up a DAO loop and read each of the records in several of the
> likely tables, hoping one would blow and I could clean out a corrupted
> record - but no cigar.
> 
> I didn't ask them if anything changed in their system right before
> this happened - I'll have to ask them tomorrow. But everybody has the
> same problem.
> 
> I'm at a loss.  Any WAGs?
> 
> MTIA
> 
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com <http://www.bchacc.com/> 
> www.e-z-mrp.com <http://www.e-z-mrp.com/> 
> 
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>