Carlos Alberto Alves
caa at highway.com.br
Fri Nov 7 08:49:12 CST 2003
On Tue, 04 Nov 2003 16:01:18 -0800, MartyConnelly <martyconnelly at shaw.ca> wrote: > 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, >> >> >> >> > Hi People! Charlotte, Francisco and Marty thanks very much for your input. I have already downloaded Jet 4.0 SP3 and SP7 for WinNT. It seems SP6 is not available anymore. I was just waiting your opinions to make the update. ;-) -- ************************************** * Carlos Alberto Alves * * Child Neurologist * * Systems Analyst/Programmer * * Rio de Janeiro, Brazil * * mailto:caa at highway.com.br * **************************************