Actually, Roy gave pretty complete instructions.
1. Create a new query (select "Design View" from the list of possibilities
when you go to create the query)
2. Do not select any tables from the dialog that appears (just hit Close).
3. Switch to the SQL view (the left-most button on the button bar should
give you this choice, or you can select it from the View menu)
4. Type the SQL Roy gave you into the window.
5. Run the query.
--
Doug Steele, Microsoft Access MVP
(no private e-mails, please)
Liz said:
thanks for your reply but I am lost - im sorry i shouldve mentioned that i
am
a new user - i need step by step instructions - i would really appreciate
it.
i have to update this database - it has 500+ tables and i have to clear or
rename the in active ones - i would really appreciate it!!!! THANKS!
RoyVidar said:
Liz said:
print a simple list of all the tables. I used the documenter but I only
need
a list of the names of the tables - can this be done? can I print the
list
continuously (not each table on a seperate page)? (PS I cant download
anything - work network restrictions.)
Create a new query, but without selecting any tables. Hit SQL view, and
paste in the following
SELECT
[Name]
FROM
MSysObjects
WHERE
[Name] Not Like "MSYS*"
AND
[Type] IN (1, 4, 6)
ORDER BY 1
The different types, I think is;
1 = native tables
4 = ODBC linked tables
6 = linked Jet tables
You can print this query, or base a report on it, which should give you
a bit less pages ;-)