Re: Finding tables in MS Access database

2009-06-29 Thread Claude Schneegans
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 whic

Finding tables in MS Access database

2009-06-29 Thread Chad McCue
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. SELECT MSysObjects.Name F