RE: Get List of tables in a DB

2002-10-15 Thread S . Isaac Dealey
: 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

RE: Get List of tables in a DB

2002-10-14 Thread Jeffrey Polaski
. 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

Get List of tables in a DB

2002-10-10 Thread James Johnson
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]

Re: Get List of tables in a DB

2002-10-10 Thread Jon Hall
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

RE: Get List of tables in a DB

2002-10-10 Thread James Johnson
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