UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> View External Tables, Any Version    
 
   
isladogs
post Nov 22 2019, 01:02 PM
Post#1


UtterAccess VIP
Posts: 2,181
Joined: 4-June 18
From: Somerset, UK


Some time ago, at the request of UA member payfast8898 I uploaded an example app List External Tables
The app allows you to view a list of all local/linked/hidden & system tables in any external Access app.
I deliberately excluded deep hidden system tables from that list

I was contacted by payfast yesterday who informed me that tables with attachment fields were being omitted from the list
Further investigation revealed that was also the case 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 values covered in this app is currently:

Attached File  TableTypes.PNG ( 37.56K )Number of downloads: 8


I would be grateful to any feedback on its use and information on any other 'missing' Flags values you may have with any of your linked tables.
In particular any additional Flags / Type values, if you have access to any linked Sharepoint/Data Services/HTML/Outlook/DBase/Azure tables

I also intend to release an updated version of this which will also allow you to view any external tables

NOTE:
I also strongly recommend an excellent external tables utility created using .net by Albert Kallal and available here
Attached File(s)
Attached File  ListTables_v1.7.zip ( 74.32K )Number of downloads: 8
 

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
gemmathehusky
post Nov 25 2019, 09:40 AM
Post#2


UtterAccess VIP
Posts: 4,752
Joined: 5-June 07
From: UK


@colin

What would be interesting is understanding why those tables were missed in the first place. (I think that is what you are saying)

I suspect it might be because you were working from system tables - I would do this sort of thing with DAO and I doubt very much whether DAO would omit tables.

--------------------
Dave (Male)

(Gemma was my dog)
Go to the top of the page
 
isladogs
post Nov 26 2019, 05:29 AM
Post#3


UtterAccess VIP
Posts: 2,181
Joined: 4-June 18
From: Somerset, UK


Getting a list of all the tables isn't the issue.
I'm providing options to view local/linked/hidden/system tables (as well as deep hidden tables in my own version)

Attached File  ListExternalTables.PNG ( 25.09K )Number of downloads: 2


To identify each I've been collecting Flags values (from MSysObjects) for each type of table
Also Type =1 for local tables, 4 for linked ODBC and 6 for linked Access
So far I have 34 different values (including 7 deep hidden which I've omitted below)

Attached File  TableTypes.PNG ( 68.2K )Number of downloads: 3


If the Flags value for a table was missing from the list, the table was excluded from the displayed results
I've now added info on linked tables from HTML, Outlook and DBase.
I would still like info on linked tables derived from Sharepoint & DataServices

If you know an easier/better way of differentiating all the different types of tables, I'd be very pleased to hear.
The published info: TableDefAttributeEnum enumeration DAO doesn't fully cover what I need here

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 
isladogs
post Nov 27 2019, 08:28 PM
Post#4


UtterAccess VIP
Posts: 2,181
Joined: 4-June 18
From: Somerset, UK


A further update to version 2.3

This includes the following changes:
a) data related to complex local tables e.g. those used with attachment fields, multi value fields & memo fields with column history
b) data for linked tables from Outlook, HTML and DBase

Attached File  TableTypes.PNG ( 78.26K )Number of downloads: 4


c) a new feature allowing you to view the contents of external tables (except for complex tables) within the utility.
This is done without the need to link any of the external tables

Attached File  MainForm.PNG ( 141.49K )Number of downloads: 2


Attached File  TableViewer.PNG ( 215.65K )Number of downloads: 3


Instead it uses a local query definition that for safety reasons has been made read only.
However it is very easy to modify this to allow the external tables to be directly edited from the utility if you wish!
See the comments in the code for frmTableViewer. TAKE CARE if you do so

Once again, I have deliberately excluded deep hidden tables from this utility

Feedback on this utility would be much appreciated.

NOTE:
I still need info for linked tables from Sharepoint and Data Services.
If any of you use either of these types of linked table, I would be very grateful for details of their Flags & Type values in the system table MSysObjects
Attached File(s)
Attached File  ViewExternalTables_v2.3.zip ( 362.35K )Number of downloads: 3
 

--------------------
Colin (Mendip Data Systems)
Website, email
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    19th February 2020 - 04:36 AM