Rocky Smolin
rockysmolin at bchacc.com
Mon Aug 22 20:35:54 CDT 2011
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/>