You need read permissions on table 'MSysObjects', you have to set thee inside Access, once you have, the following query should return table names ok.
select MSysObjects.Name from MSysObjects where (((MSysObjects.Flags)=0) AND ((MSysObjects.Type)=1)) order by MSysObjects.Name Craig. -----Original Message----- From: Dick Applebaum [mailto:[EMAIL PROTECTED]] Sent: 07 October 2002 12:12 To: CF-Talk Subject: How to get MS-Access Table & Column info without cfobject I used to be able to get system info from a MS-Access DB using cfobject & ADO. I can't do that anymore because I am running CFMX on Mac OS X (Linux), The MS-Access database is running under emulated windows. This is a large Access97 database & I can manipulate it OK from CFMX (I know some of the table names). In SQL Server there are system calls you can issue to the db to get table names, column names, column attributes, etc. Can you do a similar thing with MS-Access 2000? For some reason I cannot open the database either in Access97 or Access2000 - It just hangs. TIA Dick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
