I just want to...

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

Guest

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.)
 
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.)
Click to expand...

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 ;-)
 
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.)
Click to expand...

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 ;-)
Click to expand...
 
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.)
Click to expand...

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 ;-)
Click to expand...
Click to expand...
 
I have not heard of an access DB with 500+ tables.

--
Wayne
Manchester, England.



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.)
Click to expand...

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 ;-)
Click to expand...
Click to expand...
 
Back
Top