This info is not made readily available unless you unlock it.
You need access to the database...
Open the database
Go to tools-->Options
Check the box under *show* that says *system Objects*. You will notice that
several new tables appear in table view with the prefix MSys -
MSysAccessObjects, MSysAces, MSysObjects, MSysQueries, MSysRelationships,
and there may be a few others depending on your version of Access.
Now Go to Tools-->Security-->User and Group Permissions
Select the MSysObjects table and check the box that says "Read Data"
Then...
<Cfquery name="getSysData" datasource="cfdocexamples">
SELECT UpdateDate FROM MSysObjects
</CFQUERY>
<cfdump var="#getSysData#">
Jim Eisenhauer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:334786
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
