Could not delete from specified Tables

[charliemopps]

I would like to erase my table prior to updating it.

I have created a Delete Query that checks if the primary key "Is Not Null" and deletes. I've tried running the query based on many other parameters, but I always recieve the same error:
"Could not delete from specified Tables"

any ideas?

Or is there another way to erase this table before I append to it?

 

[Husan]

are you trying to delete a table or delete the data from a table? the primary key should not contain nulls anyway.

 

[charliemopps]

figured it out...

"Set the UniqueRecords property to Yes."