[AccessD] A2k - BE corruption???

You must first update to Jet SP3 then update to higher level SP's at 
least there used to be warnings about this. The highest SP so far is SP7 
for Win9x and WinNT; SP8 for WinXP 2000 and 2003. SP8 fixes some Oracle 
interface problems. SP7 and 8 are inclusive of patches from SP 4 through 7
Jet SP7
http://support.microsoft.com/default.aspx?scid=kb;EN-US;282010
Jet 3.5 SP3
http://www.microsoft.com/downloads/details.aspx?FamilyID=7e82ef88-52ec-4a8f-8bb2-8b06d6cb668d&DisplayLang=en



Francisco H Tapia wrote:

> 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,
>
>
>
>

-- 
Marty Connelly
Victoria, B.C.
Canada