System Table Names for Access 2000

[Bill Cook]

I uploaded an Access 2000 database to my website host as a
back end to online store, among other things. I built
an .ASP page to run JetSQL scripts for db maintenance, and
it works fine for my needs. But I can't always remember
the names of the various tables and queries I've written.
Using schema, at some point, I was able to reveal a list
of system tables, one of which held the names of all data
objects. Only now I can't remember what it was called or
how I was able to find it.

Does anyone know the name of the system table that holds
the names of all data objects? Anyone know a reference to
the names of Access 2000 system tables?

Thx.

 

[Duane Hookom]

You can query the msysObjects table. You are most interested in the [Name]
and [Type] fields.

 

[TC]

Why use unsupported system tables, when you can get the same (or more)
information using fully supported means?

For example:

dim db as database, td as tabledef
set db = currentdb(0
for each td in db.tabledefs
debug.print td.name
next
set db=nothing

& so on with other containers.

HTH,
TC

 

[Bill Cook]

Thx both. Very helpful.

-----Original Message-----
Why use unsupported system tables, when you can get the same (or more)
information using fully supported means?

For example:

dim db as database, td as tabledef
set db = currentdb(0
for each td in db.tabledefs
debug.print td.name
next
set db=nothing

& so on with other containers.

HTH,
TC





.