>Jim,
>How do you remove the alias reference from the append from statement? The file was created earlier in the program using a create file statement.
>This routine has always worked on my development system. It only began giving us problems when moved to the client site. COuld there be an incompatibility problem? THe client used VFP 5.0A and just installed the patches. I'm really confused.
>
>Thanks in advance for your help.
>
Barry,
Your append from commadn was APPEND FROM Blah FOR Blah.Field = Value and it should be APPEND FROM Blah FOR Field = Valu, this becasue no matter wht you type ther the FOR is evaluated against the target table, that is the one you are appending to, not the one you are appending from. I don't if that is an issue or not with access denied error.
Are both your VFP and the clients VFP the same version? If not make it that way. Different versions can cause all sorts of weirdness.