Re: displaying tablenames

[Precia Carraway, Sr. Application Developer]

Ron,   I have the code at home, so if you are willing to wait a bit, I'll send it to you this evening (remind me).  If you want to find out before then, Google "Access DDL" Access Data Definition Language (DDL): Creating and Altering Tables On The Fly http://www.databasejournal.com/features/msaccess/article.php/3460771   Sorry that was sooooo big.  This will help.    First thing you'll have to do is turn on a few things in Access before you can use DDL.  I think that's in the article as well.    Precia     -- Precia Carraway   Senior Applications Developer/Analyst Emory University School of Medicine Office of Information Technology Services 1256 Briarcliff Road NE Bldg A, Room 304N Atlanta, GA 30306 404.727.7591 [EMAIL PROTECTED]   ----- Original Message ----- From: Ron Mast To: list@dfwcfug.org Sent: Tuesday, May 03, 2005 10:43 AM Subject: displaying tablenames Hi All, Is there a way to display all the tables in an access database, or any database in CF?  Thanks in advance.   Ron Mast Webmaster Truth Hardware Ph: 507-444-4748 Fx: 507-444-5361 www.truth.com   _______________________________ This e-mail and any files transmitted with it are confidential and are intended solely for the use of the individual to whom they are addressed.  If you are not the intended recipient or the individual responsible for delivering the e-mail to the intended recipient, please be advised that you have received this e-mail in error and that any use, dissemination, forwarding, printing, or copying of this e-mail is strictly prohibited.