Attached is an update to version 1.7
As before, the app allows you to view a list of all local/linked/hidden & system tables in any external Access app.
Once again I have deliberately excluded deep hidden system tables from that list
I was contacted by UA member payfast8898 yesterday who informed me thattables with attachment fields were being omitted from the list
Further investigation revealed that was also true for tables containing MVFs and column history in memo fields.
These tables are unusual in that each is linked to a deep hidden system table 'behind the scenes' and all have Flags value 262144 in MSysObjects (or 262152 if hidden in the nav pane)
I've now updated this utility to include those types of table as well
This should work in all versions from A2007 onwards
I have tested this version on linked Access/SQL/Excel/csv/text/XML tables
The full list of Flags/Type values covered in this app is currently:
I would be grateful to any feedback on its use together with information about any other 'missing' Flags values you may have with any of your linked tables.
In particular please supply any additional Flags / Type values neede
d if you have access to any linked Sharepoint / Data Services / HTML / Outlook / DBase / Azure
I also intend to release an updated version of this utility which will also allow you to view the contents of any external tables
1. I also strongly recommend an excellent external tables list/view utility created using .net by Albert Kallal
and available here
2. As this thread is closed, please provide feedback by PM or you can email me