H Heather May 4, 2010 #1 I keep getting a "Property Value is too large" error when I am trying to delete records in a database. Any suggestions?
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] May 5, 2010 #2 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.
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 May 5, 2010 #3 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.
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.
