[AccessD] Removing Extended Properties from stored queries?

Ryan W wrwehler at gmail.com
Fri Jun 25 14:23:53 CDT 2021


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


More information about the AccessD mailing list