That sounds like a security problem. Make sure you have full rights to the file and you should get the results you're looking for.
Scott Scott Brader Prairie Software Development LLC 101 East Sadd Street PO Box 235 North Prairie, WI 53153-0235 Phone: 262.392.9173 Fax: 262.392.9174 Toll Free: 888.821.3427 Mobile: 262.490.1376 <http://www.prairiesoftdev.com> Amateurs practice until they get it right, Experts practice until they can't get it wrong. -----Original Message----- From: mr_urc [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 30, 2002 15:08 To: CF-Talk Subject: RE: Access table names Quoting Scott Brader <[EMAIL PROTECTED]>: > You can get a list of all tables in an Access database by querying the > system tables. The system tables will all start with MSys. All of the > other > records returned by the query will be the rest of the tables in the > database. > > SELECT MSysObjects.Name > FROM MSysObjects > WHERE (((MSysObjects.Type)=1)); > > This may not be the best choice, but it works. This seems to be what I was looking for. Unfortunately, I get this: "Record(s) cannot be read; no read permission on 'MSysObjects'." THWARTED AT EVERY TURN! Clearly, Access has a will of it's own and it wants me to have a bad day. But I'll show it. I'll just tell my boss we're going to do this on a weekend instead of today. We have the least hits on Saturday. Thanks anyway! -- If you hate the interface, blame Kevin. ______________________________________________________________________ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
