[AccessD] A2k - BE corruption???

I would try and update his copy of Jet to SP6 to see if your results change.

Carlos Alberto Alves wrote:

> Dear Mates:
> I would like to have your opinion on this matter. I developed an A2k 
> database system with three identical FE's and one BE. It has data from 
> jan2001 to now. Upon executing a simple select query I noticed that I 
> could not retrieve any records from 2002. The same query executed on a 
> BE backup copy from jul2003 returned all due records.
> Is this a BE corruption??? I tried “Compact and repair...”, 
> JetComp and import all tables to a new BE with no better results.
> Things that called my attention:
> 1- I use Jet 4.0 SP6 and my client uses something older than SP3;
> 2- I use Access 2000/Office 2000 and my client uses Access 2000/Office 
> 97.
> Thanks for any input,



-- 
-Francisco