In order to query MSysObjects you must have some permissions set in the security settings of the database.
If you have CF 8, you should also be able to use CFdbInfo. Otherwise, there is still CFX_ODBCinfo: http://customtags.internetique.com/ODBCInfo/E/TestODBCInfo.cfm which is not free, but which works on any ODBC datasource under Windows and under CF 8, 7, 6, 5, 4, and may be even lower. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:324044 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
