Interesting - when I try this I get a read error??
[Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read
permission on 'MSysObjects'.
je
-----Original Message-----
From: Zachary Bedell [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 22, 2000 11:23 AM
To: '[EMAIL PROTECTED]'
Subject: RE: List of tables in Access 97
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Try:
SELECT Name
FROM MSysObjects
WHERE Type = 1
That'll get you all tables. If you want to exclude all of the system
tables, one of the following added to the WHERE clause should do it.
AND Name Not Like 'MSys%'
- -- OR --
AND Flags = 0
I'm not entirely sure about the Flags thing. In the DB I'm looking
at, all system tables have non-zero flags & all non-system tables
have zero flags. YMMV...
BTW, if you want to see these in access, go into the options and
check Show Hidden & Show System. They're both under the View tab in
AC2k. I don't know if it's in the same place in other versions.
Hope that helps.
Best regards,
Zac Bedell
========================================
Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.
Please include original message in any replies -- I get a
lot of email every day, and I have a REALLY bad memory...
So I don't always remember everything that was said.
Thanks!
> -----Original Message-----
> From: Robert Everland III [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, June 21, 2000 9:21 PM
> To: [EMAIL PROTECTED]
> Subject: List of tables in Access 97
>
>
> How can you get a list of tables in Access?
>
> Bob
> --------------------------------------------------------------
> ----------------
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=list
> s/cf_talk or send a message to
> [EMAIL PROTECTED] with 'unsubscribe' in the body.
>
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>
Comment: Please use PGP!!!
iQA/AwUBOVIvNQraVoMWBwRBEQKPnACgnQ82qCyfabCjxGTWXavYzsyPGB8AoO5n
XGrobI8oGbwnJJrrpTVshhnc
=uR0y
-----END PGP SIGNATURE-----
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
