which object holds all the table info

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would to know how retrieve all the table names in an application open or not.
I am using access 2002 xp
 
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.
 
What are you trying to do?

--
Good Luck
BS"D


jalewis999 said:
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.
Click to expand...
 
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.
 
Back
Top