Also, I'm sure there is a more elegant way of getting the modified date but a cfdirectory listing of the MDB's parent directory should return a list of files in that directory. One of the returned columns is "DATELASTMODIFIED"
Just throw a filter on the cfdirectory tag to only get the MDB file and voila... hack city. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bobby Hartsfield [mailto:bo...@acoderslife.com] Sent: Wednesday, June 23, 2010 5:51 PM To: cf-talk Subject: RE: How can you GetFileInfo for a datasource? I believe you can get all the available datasource info through the admin api. Something like this should spit it all out for you. <cfset adminObj = createObject("component","cfide.adminapi.administrator") /> <cfset isLoggedIn = adminObj.login(yourCFAdminPassword) /> <cfif not isLoggedIn> LOGIN FAILED <cfelse> <cfset dbObj = createObject("component","cfide.adminapi.datasource") /> <cfdump var="#dbObj.getDatasources()#" /> </cfscript> That would dump all datasources and their settings. I'd assume the access path would be in there since it is one of the settings when creating access datasources. .:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: Bryan Stevenson [mailto:br...@electricedgesystems.com] Sent: Wednesday, June 23, 2010 5:35 PM To: cf-talk Subject: Re: How can you GetFileInfo for a datasource? If you know the absolute path to the DB.... You can just set a global var that holds that path. Of course that isn't the most graceful solution, but I'm not sure if there is a way to programmatically determine the absolute path of an Access DB used in a CF datasource. If the DB won't be moving around, then I'd just do something along the lines of what I suggested. HTH Cheers Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:334791 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm