I have an MS Access 2002 database with about 70 queries which I use only every couple of months for a data verification process. I have the Hidden attribute turned on in Properties so that these queries are not visible and cluttering up the list of other queries when I don’t want to see them.
My problem is that when I do reveal them and open the queries, in many cases the Hidden attribute becomes turned off, so that I have to open the properties and turn it back on again for each affected query. Does anyone have any tips as to why this is happening and what can be done about it?
I have searched the Microsoft Knowledge base and can’t find any reference to this issue, and haven’t been able to find anything useful on the Web.