Solved Count Linked Tables

[Kha]

Hi
I want to make sure that I have 5 tables linked to my FE DB because I don't want to miss any one by mistake
So how can I count how many tables are linked to my FE DB?

 

[theDBguy]

You could try DCount(). For example:

DCount("*", "MSysObjects", "Type=6")

(untested)

 

[Pat Hartman]

It depends on what type of tables are linked.
ODBC tables are type = 4
Both Jet/ACE AND Excel show as Type = 6 but for Excel both the Connect and Database columns have data but for Jet/ACE, the Connect is null

Here is a table of the Type codes. Check your own database. If you have a type that is not in this list, please let me know so I can add it to my list.

Type    TypeDesc
-32768    Form
-32766    Macro
-32764    Reports
-32761    Module
-32758    Users
-32757    Database Document
-32756    Data Access Pages
1    Table - Local Access Tables
2    Access Object - Database
3    Access Object - Containers
4    Table - Linked ODBC Tables
5    Queries
6    Table - Linked Tables or Files
8    Relationships
9    Constraints

 

[Kha]

Thank you very much