>I have tried it both with Deleted = yes and with Deleted = no...
>
>Both fail 2% of the clients. The way Access describes it, however, a yes on Deleted allows access to avoid deleted fields. I am most likely incorrect however. I will look into it further.
>
>Thank You

You are correct. Deleted=Yes ignores deleted records while Deleted=No brings them in. Now the appropriate place to look for these details is the VFP driver help and not in Access, although this is not documented in the MSDN online help for the VFP ODBC driver. (under SqlDriverConnect)

There are several MSKB articles that use this parameter though.