You can try working around this problem by creating a separate table, possibly with the same structure, but with an index on the field(s) of your UNIQUE clause. Then copy all the rows from the first table to the second table, making sure that the UNIQUE field(s) does(do) not exist. The index is there to speed up your search. At the end of the procedure, you will have the UNIQUE records. You might want to use this without a separate table, but you would have to create an in-memory array where the UNIQUE fields would be stored, and compared against. If you don't want to do nothing of this, you will have to upgrade to a better database engine, like SQL Server CE 2.0. Good luck! João Paulo