I'm trying to delete a huge amount of data and says something

I'm trying to delete a huge amount of data and says something

Post by TWFyY2 » Sat, 23 Feb 2008 19:55:00


Hello. I have a table with a huge amout of data. The data comes from an ODBC
table and is copy to a local table.

When I have to delete the data of the local table it returns me a message
sauing that I have no enough disk free space to cancel the operation. For me
is ok, but I have 22gb of free memory.

Is it normal this messages?


Regards,
Marco
 
 
 

I'm trying to delete a huge amount of data and says something

Post by TWF1cmljZ » Sat, 23 Feb 2008 21:56:01

Marco,

How are you trying to delete the records? By selecting in the table and then
press delete? If so try to create a delete query that should work.

hth
--
Maurice Ausum

 
 
 

I'm trying to delete a huge amount of data and says something

Post by Dirk Goldg » Sun, 24 Feb 2008 00:21:02


If I understand you correctly, this is normal. What it means is that the
operation has exceeded the limits of what can be executed in a transaction
that can be rolled back. Executing it as a delete query may avoid the
message, though I'm not sure of that.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)