>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...
>
The database is created in a 3rd party application and a copy is sent to my
website every 15 minutes, so it isn't practical to change the database itself.
I dislike .Net but it certainly was simple there. It took 3 lines:
db = Session("DBpath") & "myDB.mdb"
Dim myFile as FileInfo = New FileInfo(db)
Dim ModDate as Date = myFile.LastWriteTime
> 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:334789
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
