List of all table names beginning with "ABCDE"

[MLH]

I have an Access 2.0 app I still use.
How best can I list all tables in a combo-
box on an Access 2.0 form - just tables
beginning with "ABCDE"? Bear in mind
that I'm adding new tables to the app
frequently - the method would have to
be dynamic rather than static.

[Allen Browne]

Set the RowSource of the combo to this query statement:

SELECT MsysObjects.[Name] FROM MsysObjects
WHERE ((MsysObjects.[Type] IN (1, 4, 6))
AND ([Name] Like "ABCDE*"))
ORDER BY MsysObjects.[Name];

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"MLH" <CR**@NorthState.net> wrote in message
news:cc********************************@4ax.com...

I have an Access 2.0 app I still use.
How best can I list all tables in a combo-
box on an Access 2.0 form - just tables
beginning with "ABCDE"? Bear in mind
that I'm adding new tables to the app
frequently - the method would have to
be dynamic rather than static.

[Thelma Lubkin]

Allen Browne <Al*********@SeeSig.Invalid> wrote:
: Set the RowSource of the combo to this query statement:

: SELECT MsysObjects.[Name] FROM MsysObjects
: WHERE ((MsysObjects.[Type] IN (1, 4, 6))
: AND ([Name] Like "ABCDE*"))
: ORDER BY MsysObjects.[Name];

I've been able to find that Types 1 and 6 refer to tables and
attached tables respectively, but I haven't seen any mention of a Type
4. What is it and where can I find a complete definition of the
MsysObjects table?

thanks, --thelma
: --
: Allen Browne - Microsoft MVP. Perth, Western Australia.

[Allen Browne]

I understand that 4 is used for ODBC linked tables.

5 = queries.
-32768 = forms
-32764 = reports
-32761 = modules.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Thelma Lubkin" <th****@alpha2.csd.uwm.edu> wrote in message
news:e8**********@uwm.edu...

Allen Browne <Al*********@SeeSig.Invalid> wrote:
: Set the RowSource of the combo to this query statement:

: SELECT MsysObjects.[Name] FROM MsysObjects
: WHERE ((MsysObjects.[Type] IN (1, 4, 6))
: AND ([Name] Like "ABCDE*"))
: ORDER BY MsysObjects.[Name];

I've been able to find that Types 1 and 6 refer to tables and
attached tables respectively, but I haven't seen any mention of a
Type
4. What is it and where can I find a complete definition of the
MsysObjects table?

thanks, --thelma
: --
: Allen Browne - Microsoft MVP. Perth, Western Australia.

[MLH]

Thanks. That worked GREAT!

[Larry Linson]

"Thelma Lubkin" <th****@alpha2.csd.uwm.edu> wrote

4. What is it and where can I find a
complete definition of the
MsysObjects table?

It is one of Access' System Tables, which you can set an option to display,
but which you aren't allowed to update. It is officially undocumented.

Various users have figured out much of its structure and values, some of
which has been published "unofficially" by those users. But, be aware that
the System Tables have changed to some extent in every version of Access, so
what works today may not work when the next version is released.