Delete Query

S

Sean Nijenhuis

Hi, thanks for your time.

I'm running a delete query on a table with about 300000 records in it. The
database size before the query is run is 36megs.

On running the query the database grows to 1.7Gb.

Please can someone shed some light on this and is there a way of deleting
records without increasing the size of the database?

Thanks
Sean
 
S

Sal Rosario

You should Compact and Repair your database to reclaim the space consumed by
your data and application objects even after deleting.

Regards,

Sal Rosario
Database Cosultant in NJ
www.salrosario.com
 
S

Sean Nijenhuis

Thanks for the reply.

Understood, but its in running this query that in some instances i reach the
2gb limit and all goes to pieces. So i cant really compact, delete some,
compact, delete some, compact, etc?
 

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

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Some mail merge fields not pulling into document 2
Delete Query Help 2
query to show where no data in a stated column 0
Make table query: [Enter 1] AS Test 1
Disable Pop Up Box 4
query field names changing to expr#: 8
Query producing different results each time it is run 2

Top