<br>I USE COLDFUSION..THE FOLLOWING CODE IN COLDFUSION IS SUPPOSED TO GET ME THE LIST OF THE TABLE NAMES IN MY DATABASE.<br><br><br><cfquery datasource="myDatasource" name="GetTables"><br> SELECT MSysObjects.Name FROM MSysObjects<br> WHERE (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1))<br> ORDER BY MSysObjects.Name<br> </cfquery><br><br><br>WHEN I RUN THIS CODE THE ERROR IT SHOWS ME IS AS BELOW..CAN ANYONE TELL ME HOW TO MAKE THIS MSSsysObjects accesible.<br><br>ODBC Error Code = 42000 (Syntax error or access violation)<br><br> [Microsoft][ODBC Microsoft Access 97 Driver] Record(s) can't be read; no read permission on 'MSysObjects'.<br><br><br>
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
MSsysObjects
- Thread starter vista
- Start date
Someone may have security set up on that db, you need to find out...normally the default logon (Admin) has Read access to those files, so you need to get a userid/pwd to logon before running that sql. Also, that SQL will only return local Access tables, not ODBC-linked or ISAM-Attached tables...not sure if that's ok or not.<br>--Jim
- Status