ACCESS Queries?

I have a db, and in developing it, I've created hundreds and hundreds of queries.
Now as I am learning, I see that I can create queries "on the fly", with code like:

Dim cnnl As ADODB.Connection
Set cnnl = CurrentProject.Connection

Dim myRecordSet As New ADODB.Recordset
myRecordSet.ActiveConnection = cnnl

Dim mySQL As String
mySQL = "SELECT *"
mySQL = mySQL + " FROM tblCustomers"
mySQL = mySQL + " WHERE ((CustomerID = 1 ))"
myRecordSet.Open mySQL

Set myRecordSet = Nothing
Set cnnl = Nothing

My question is, do you think it's better to code the query on the fly like this, or to create them as permanent ACCESS objects, as I have done?

My feeling is, that the ADODB method is probably more efficient, and if I can delete those many existing queries, and create recordsets on the fly, only when needed, the db would be a LOT smaller, in terms of MB, becuse of all the objects I'll be able to delete from the Queries window. Or, are they relatively insignificant in terms of MB?

Or, should I adopt the "IF IT AIN'T BROKE DONT FIX IT" approach, because all those queries do work, and there are huge numbers of forms dependant on them.

The size IS a factor, the db is over 50MB now, and I'd like to optimize it.