Prev: Stop Doesn't Stop Access 2003
Next: blank form
From: Heather on 4 May 2010 18:42
I keep getting a "Property Value is too large" error when I am trying to
delete records in a database.

Any suggestions?
From: Arvin Meyer [MVP] on 4 May 2010 19:54
"Heather" <Heather(a)discussions.microsoft.com> wrote in message
news:87A7231D-0118-41C7-8B7B-875E102501CF(a)microsoft.com...
>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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


From: golfinray on 4 May 2010 19:58
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.
--
Milton Purdy
ACCESS
State of Arkansas


"Heather" wrote:

> I keep getting a "Property Value is too large" error when I am trying to
> delete records in a database.
>
> Any suggestions?
 | 
Pages: 1
Prev: Stop Doesn't Stop Access 2003
Next: blank form