[AccessD] Removing Extended Properties from stored queries?

[Ryan W]

Well.. nobody bit on my question.

I just blew away the properties in the exported file and re-imported the
file.  Problem solved... in a roundabout manner anyway.


On Fri, Jun 25, 2021 at 2:23 PM Ryan W <wrwehler at gmail.com> wrote:

> Is there a way to remove the extended unseen properties from stored
> Queries?
>
> I'm using the undocumented SaveAsText to dump forms/reports/modules/etc to
> file and I'm seeing some remnants of hidden query properties in one query
> that were originally in another query.
>
> These are from a query that was once called qryBottleOrderCompleteness. I
> copied it to qry_OtherMname and changed the SQL text (since it was a
> passthrough) but these remain.  I only see them in my data dumps/git
> commits...
>
>
> Begin    Begin        dbText "Name" ="qryBottleOrderCompletness.ClientID"        dbInteger "ColumnWidth" ="1665"        dbBoolean "ColumnHidden" ="0"        dbLong "AggregateType" ="-1"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.ProjectID"        dbLong "AggregateType" ="-1"        dbInteger "ColumnWidth" ="1860"        dbBoolean "ColumnHidden" ="0"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.BottleOrder"        dbLong "AggregateType" ="-1"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.TestCode"        dbLong "AggregateType" ="-1"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.BottleOrderTestQuantity"        dbLong "AggregateType" ="-1"        dbInteger "ColumnWidth" ="2730"        dbBoolean "ColumnHidden" ="0"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.WorkOrders"        dbLong "AggregateType" ="-1"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.CountOfTestsLogged"        dbLong "AggregateType" ="-1"        dbInteger "ColumnWidth" ="2340"        dbBoolean "ColumnHidden" ="0"    End    Begin        dbText "Name" ="qryBottleOrderCompletness.PctReceived"        dbLong "AggregateType" ="-1"    EndEnd
>
>