: Get List of tables in a DB
Hi,
Is there a CF function or SQL statement that returns a list of table in
an Access DB?
Thanks
***
James Johnson
SMB-Studios
Innovative Online Learning for Spirit, Mind and Body
www.smb-studios.com
[EMAIL PROTECTED
.
Jeff Polaski
The cow is of the bovine ilk;
One end is moo, the other, milk.
-- Ogden Nash
-Original Message-
From: James Johnson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 4:26 PM
To: CF-Talk
Subject: Get List of tables in a DB
Hi
Hi,
Is there a CF function or SQL statement that returns a list of table in
an Access DB?
Thanks
***
James Johnson
SMB-Studios
Innovative Online Learning for Spirit, Mind and Body
www.smb-studios.com
[EMAIL PROTECTED]
Here is my snippet.
!---
First 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..
---
cfquery datasource=email
Great. Thank you. :)
-Original Message-
From: Jon Hall [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 10, 2002 4:34 PM
To: CF-Talk
Subject: Re: Get List of tables in a DB
Here is my snippet.
!---
First go to Tools - Options - click on Hidden Objects and System
Objects, then go
5 matches
Mail list logo