Access 97 & Vista Home Premium 64 Bit COMPACT AND REPAIR
Posted on 2009-03-30
I am running Access 97 on a Vista home premium 64 bit OS platform. In order to make Acc97 run on the is os I had to do the following;
Run the office SP1, SP2 and the Jet 3.5 patches.
Access now runs fine on this machine, EXCEPT:
I have written an Acc97 routine that performs a compact & repair on the dB. I ran this today and the system "hung". I let it sit for at least 30 mins (20 mns more than it took under XP OS) and finally got a "program not repsonding" message when I clicked on screen. The dB was hosed, completely. I brought up a back up and tried doing a compact under the Acc97 direct environment, bypassing my code. Compact worked. Did a repair the same way and the system hung again, completely destroying the dB. BTW... running the SAME routines under Vista home basic 32 bit runs fine.
I have read (in various places) that the Jet 4.0 patch "may" solve this problem, but I saw nothing that directly points to this issue.
1) Is there hope to make this work?
2) Will Jet 4.0 fix this issue?
3) What else could Jet 4.0 do to my app?
While not a show stopper, this is a major point of issue that i need to address. the dB is over 250 Mb in size, and has worked flawlessly under XP Pro and Vista home basic.
FORGOT TO ADD: Vista Home Premuim OS is currently at SP1 level. Sorry. MR