Is there a way to delete queries from an Access file?

[neov]

I'm using data from an old, old Access file, and there are over 200 queries - is there any way to quickly delete them other than going through and deleting them one by one?

Thanks!

 

[Norie]

Yes

 

[neov]

details?

 

[Norie]

Sorry had to rush off.

Do do this you'll need code.

Something like this would delete every query in the database.

Sub DeletAllQueries()
Dim qdf As QueryDef
    
    For Each qdf In CurrentDb.QueryDefs
        CurrentDb.QueryDefs.Delete qdf.Name
    Next
End Sub

To only delete particular queries you'll need to add some sort of conditio or confirmation code.