correct me if i am wrong (i am not a .Net developer in any way), but
doesn't your .Net code expect you to provide the path to the db as well?
or is Session("DBpath") some variable automatically created by .Net?
Azadi
On 24/06/2010 05:43, John Pullam wrote:
>> 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:334799
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
