System Table Names for Access 2000

  • Thread starter Thread starter Bill Cook
  • Start date Start date
B

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.
 
You can query the msysObjects table. You are most interested in the [Name]
and [Type] fields.
 
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
 
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





.
Click to expand...
 
Back
Top