I have an application that is running very slowly and i noticed there are BE tables that i have not created.
when i open these tables they are clearly created by MSAccess itself as they are not anything i would have created.
I took a copy of the BE files and deleted the data in the tables (that i could - as some of the tables would not allow me to delete anything)
and the application seems to be working lighting fast now!
I'm afraid If I do this to my main BE tables i may cause a problem i can't fix so i'd like someones feedback on what the following are and what the implications are if i delete the records (that i am allowed to delete) in these tables:
MSysAccessStorage
MsysAccessXML
MsysACEs
MSysComplexColumns
MSysNameMap
MSysNavPaneGroupCategories
MSysNavPaneGroups
MSysNavPaneGroupToObjects
MSysNavPaneObjectIDs
MSysObjects
MSysQueries
MSysRelationships
MSysResources
again i didn't create any of these and would like to know the implications of me deleting the records contained in these tables (as when i do on test data the application functions very fast (as it should).
thanks,
STeve