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" name="GetTables"> SELECT name FROM MSysObjects WHERE TYPE=1 and left(MSysObjects.name,4) <> 'MSys' </cfquery> <cfoutput query="GetTables"> #name#<br> </cfoutput> -- jon mailto:[EMAIL PROTECTED] Thursday, October 10, 2002, 7:25:43 PM, you wrote: JJ> Hi, JJ> Is there a CF function or SQL statement that returns a list of table in JJ> an Access DB? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
