which object holds all the table info

[Guest]

I would to know how retrieve all the table names in an application open or not.
I am using access 2002 xp

 

[Guest]

Try

SELECT MSysObjects.Name
FROM MSysObjects
WHERE MSysObjects.Type=1

 

[Guest]

Thanks I put it into a query and it worked fine. What I was looking for was a
bit more info on how to use it in code.

 

[Guest]

What are you trying to do?

--
Good Luck
BS"D

Thanks I put it into a query and it worked fine. What I was looking for was a
bit more info on how to use it in code.

 

[Guest]

As briefly as possible a system i am working on creates a set of tables
(prefixed with their names) for each registered user. It was designed to look
up a table for names and passwords on entry. The system itself has 2 levels
of passwords so I am trying to aliminate the Table and use the existing user
tables one of which holds the highest level password I want to use. The first
step however is to establish if any users exist. If they don't an add user is
triggered. I can use the code to establish if any users how many and their
names without the need for the extra table.
I hope this covers it. Thanks for your time.