property value error

[Heather]

I keep getting a "Property Value is too large" error when I am trying to
delete records in a database.

Any suggestions?

 

[Arvin Meyer [MVP]]

I keep getting a "Property Value is too large" error when I am trying to
delete records in a database.

Any suggestions?

Find the threshold. Delete 2 records, then 4, then 8, then ... rtc.
until you find it. That is probably the limit of your available memory.

 

[golfinray]

If you want to delet the contents of an entire table, do a delete query. Go
into sql view and type:
delete
from [yourtablename]

Run the query. Make certain that you have any data you need backed up first.