Skip to main content
P
plarts
Inspiring
February 4, 2014
Question

Last modified date of DB

  • February 4, 2014
  • 2 replies
  • 1406 views

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.

This topic has been closed for replies.

2 replies

BKBK
Community Expert
BKBKCommunity Expert
Community Expert
February 19, 2014

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().

P
plartsAuthor
Inspiring
February 20, 2014

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.

Fernis
Fernis
Inspiring
February 12, 2014

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

P
plartsAuthor
Inspiring
February 12, 2014

No, the .mdb file is outside the webroot.

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

Fernis
Fernis
Inspiring
February 12, 2014

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.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices