>Hi,
>
>I've been running a method contained in a formset for many years without issue - until today.
>
>select kwik
>set filter to
>delete for mvenue=q_venue and mrn=q_race_no
>pack
>
>In the above code, the third line (delete for mvenue=q_venue and mrn=q_race_no) totally closes the work area occupied by this table and totally erases the file kwik.dbf. I rebooted the computer and it seems to be working now, but I am concerned as to the reason, because this is part of a system installed on many user's computers.
>
>About a month ago, I switched from Windows XP to Windows 7. Not sure if that might be an issue.
>
>Any feedback would be welcome.
I'm wondering if the issue is actually with PACK. The way PACK works is it copies non-deleted rows from kwik.dbf to a temp table, deletes the original kwik.dbf, and then renames the temp table to kwik.dbf.
Windows 7 introduced many security restrictions compared to XP, especially if you have data tables in so-called "protected" folders. Maybe a security restriction is preventing one or more of the actions required for PACK to succeed.
You might want to look at Doug Hennig's whitepaper re: VFP and Windows Vista:
http://www.stonefield.com/pub/vista.zip . It's for Vista, but Win7's security restrictions are very similar to Vista. Look at the Security and Protected Folders sections.
If this was a one-time, not repeatable occurrence, a couple more ideas:
- are there many leftover temp files in your VFP temp files folder?
- is your antivirus program set to not real-time scan VFP data and temp files folders?
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up