-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
>> Try:
>> SELECT Name
>> FROM MSysObjects
>> WHERE Type = 1
>>
>> That'll get you all tables. If you want to exclude all of the
>> system tables, one of the following added to the WHERE clause
>> should do it.
>>
>> AND Name Not Like 'MSys%'
>> -- OR --
>> AND Flags = 0
>>
>> I'm not entirely sure about the Flags thing. In the DB I'm
>> looking at, all system tables have non-zero flags & all non-system
>> tables have zero flags. YMMV...
>>
> Interesting - when I try this I get a read error??
Hmmm... I didn't actually try to run that code from CF. Should check
my facts next time....
This worked for me:
Open the database in Access & change Access' options so you can see
hidden & system tables. Click on the MSysObjects table, then go
Tools->Security->User and Group Permissions. Give the Admin user
rights to 'Read Design' and 'Read Data' in the MSysObjects table.
After doing that, I was able to run the query from ColdFusion (4.0.1
thru ODBC, FYI).
If *that* doesn't work, then I guess I'm outta ideas for now...
Access isn't my beast of choice any more...
Best regards,
Zac Bedell
========================================
Zachary S. Bedell,
Chief Technology Officer,
Adirondack Technologies, Inc.
Please include original message in any replies -- I get a
lot of email every day, and I have a REALLY bad memory...
So I don't always remember everything that was said.
Thanks!
-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 6.5.2 for non-commercial use <http://www.pgp.com>
Comment: Please use PGP!!!
iQA/AwUBOVJTyQraVoMWBwRBEQIluQCeMSFeBsIe7qS0iO/7NMkJPL8Bn/gAn38b
vzfyfgEPyGSDWph8WCgVkb+d
=ZcMB
-----END PGP SIGNATURE-----
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.