jon, :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ : From: jon steele : : I need to show all the tables in a database. : I just need a list of them. I know in mysql : there's a show statement, but how can I do : this for an Access db from ColdFusion. :~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ one good place for looking for applications like this is the custom tag gallery on allaire.com. http://devex.allaire.com/developer/gallery/ a search for "tables" turned up the following promising results: CF_AccessTables <http://devex.allaire.com/developer/gallery/info.cfm?ID=CA34785A-2830-11D4-A A9700508B94F380&method=Full> CF_DBINFO <http://devex.allaire.com/developer/gallery/info.cfm?ID=8C6EAA32-24FA-11D5-8 3EF00508B94F85A&method=Full> CFX_GetTables <http://devex.allaire.com/developer/gallery/info.cfm?ID=CA3475EA-2830-11D4-A A9700508B94F380&method=Full> using other words you might be able to come up with even more fruitful results. good luck, .jeff http://evolt.org/ jeff at members.evolt.org http://members.evolt.org/jeff/