property value error

H

Heather

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

Any suggestions?
 
A

Arvin Meyer [MVP]

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

Any suggestions?
Click to expand...

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.
 
G

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.
 
Top