Ah, ok... I saw the '@' in your code where you were building the where clause parameters and figured you were trying to work with SQL. MM will translate the prefixes... I think you've probably just entered the "belt, suspenders, and staple gun" realm.

>Jason,
>
>Actually, the oledb data access call is correct. I'm using Visual FoxPro as the database. Maybe the prepending the prefix is the problem. I'll take a look. Thanks.
>
>Linda