You have to go to Tools -> Options -> click on Hidden Objects and System
Objects
then go back to Tools -> Security -> User and Group permissions -> highlight
the MSSysObjects table and then check the Read Data check box, then click ok
and you are done. Now use the query below and this will give you all of the
user tables in an access db.
SELECT name
FROM MSysObjects
WHERE TYPE=1 and
left(MSysObjects.name,4) <> 'MSys'
-----Original Message-----
From: Robert Everland III [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 21, 2000 8: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=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.
