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.
 

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 1
Property Value Too Large when establishing filed lookup 0
Getting "Could not find installable ISAM files" while Connecting vb6 with access 2003 using DAO cont 0
Auto number in an existing table 4
"Property Value too large" 1
Deleting New Record 5
Expanding the size of my report 3
LinkMasterFields Property error 1

Top