-
1. Re: Last modified date of DB
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
-
2. Re: Last modified date of DB
No, the .mdb file is outside the webroot.
Access db is great for small sites. Just one file to play with.
-
3. Re: Last modified date of DB
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.
-
4. Re: Last modified date of DB
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().
-
5. Re: Last modified date of DB
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.