Adobe Community: Message List - Last modified date of DB

Re: Last modified date of DB

forums_noreply@adobe.com — Thu, 20 Feb 2014 11:00:52 GMT

Thanks a lot, I will try this.

Other question concerning MSaccess, I understood that an mdb file will start going down after 1Go

of disk space.

I use MSacces for small sites, and it is great, so simple. (Max now is some Mo in space)

So 1Go per site , is not bad.

I understood that MSSQLserver express can come up to 10Go.

But if this is for all sites (all created DB) MSaccess will be better in term of disk space.

Your coment on that question is welcome ?

Thanks, Pierre.

Re: Last modified date of DB

forums_noreply@adobe.com — Wed, 19 Feb 2014 13:37:20 GMT

plarts wrote:

Using Access databases, (.mdb files , lighter than accdb)
How can I know when the mdb file have been last modified ?
Looking for a simple way.
If possible, by querying something ?

If you are well-versed in MS Access, you could use its embedded Visual Basic tool to create a custom version of the function FileDateTime(), say, GetFileDateTime(). Your query could then call GetFileDateTime().

Re: Last modified date of DB

forums_noreply@adobe.com — Wed, 12 Feb 2014 17:34:02 GMT

If the ColdFusion isn't set up to limit your access on the server (Enterprise version, sandbox mode), there's nothing stopping you accessing directories outside the web root.

Re: Last modified date of DB

forums_noreply@adobe.com — Wed, 12 Feb 2014 17:12:26 GMT

No, the .mdb file is outside the webroot.

Access db is great for small sites. Just one file to play with.

Re: Last modified date of DB

forums_noreply@adobe.com — Wed, 12 Feb 2014 13:02:54 GMT

Never worked with Access, but couldn't you just check the modification date on the file system for the .mdb file, if you have access to the directory it is located at? Using cfdirectory and checking the dateLastModified attribute for that file.

-Fernis

Last modified date of DB

forums_noreply@adobe.com — Tue, 04 Feb 2014 13:10:27 GMT

Using Access databases, (.mdb files , lighter than accdb)

How can I know when the mdb file have been last modified ?

Looking for a simple way.

If possible, by querying something ?

Thanks for any suggestion,

Pierre.