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
, 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
Test
-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
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
-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 =
: RE: List of tables in Access 97
I have been attempting to unsubscribe from this list for over a month.
NOW I AM GETTING LIST EMAIL WITH ATTACHMENTS!!!
IF ANYBODY IS OUT THERE, THIS HAS GOT TO STOP!!!
Please!
mailto:[EMAIL
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=listsbody=lists/cf_talk or send a
message to [EMAIL
7 matches
Mail list logo