Deleting more than 50,000 in macro (1 Viewer)

Wonderer · Oct 30, 2002

Wondering if anyone can help...

I have checked the search but no joy..

I have a simple macro that opens table and selects all then delets the contense as i need to keep the table struture however this table has roughly 106,000 records i need to delet them all regularly. But get errors as i am aware this is over the possible max for deleting

Does anyone know a way round this for example by selecting 1-50,000 and so forth

Any help would be appreciated!!

Thanks

ColinEssex · Oct 30, 2002

If the table contains dates why not use parameters in the query to only delete specific date ranges.

Col

Wonderer · Oct 30, 2002

Good idea but no date ranges any other thoughts?

Regards

ROb

ColinEssex · Oct 30, 2002

Any field will do ID_No for example or in the query set the Top n % like 25%

Col

Wonderer · Oct 30, 2002

Thanks col for your response

Where should i put this condition?

Thanks

Rob

Tim K. · Oct 30, 2002

I would use VBA to delete the table. Fast.

Try this.

Code:

Private Sub Command0_Click()
Dim dbs As Database
Set dbs = CurrentDb
dbs.Execute "Delete * From YourTargetTableNameHere"
dbs.Close
Set dbs = Nothing
End Sub

ghudson · Oct 30, 2002

How about...

Private Sub Command0_Click()
Currentdb().Execute "DELETE * FROM YourTargetTableNameHere"
End Sub

...for the same result minus a few lines of code?

Deleting more than 50,000 in macro (1 Viewer)

Wonderer

Registered User.

ColinEssex

Old registered user

Wonderer

Registered User.

ColinEssex

Old registered user

Wonderer

Registered User.

Tim K.

Registered User.

ghudson

Registered User.

Similar threads

Users who are viewing this thread