property value error

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

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

Any suggestions?
 
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Property Value Too Large when establishing filed lookup 0
Property Value too Large 1
Type mismatch error - Setting Hyperlink Base property 2
Auto number in an existing table 4
When try to delete record, required field can't be null 3
Getting "Could not find installable ISAM files" while Connecting vb6 with access 2003 using DAO cont 0
Deleting New Record 5
Expanding the size of my report 3

Back
Top