Finding tables in MS Access database
I have some code that will take a .MDB file from the client upload it to a directory and create a data source within ColdFusion. My problem is I have to find the first table within that database. I have tried the below query but keep getting a database error. cfquery datasource=myDatasource name=GetTables SELECT MSysObjects.Name FROM MSysObjects WHERE MSysObjects.Flags = 0 AND MSysObjects.Type = 1 ORDER BY MSysObjects.Name /cfquery ~| 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:324042 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Finding tables in MS Access database
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