Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / June 2004

Tip: Looking for answers? Try searching our database.

Same thing

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steven - 21 Jun 2004 15:56 GMT
I am just frustrated.  I did not think anyone would
actually read what I wrote.  I should have just reposted
the question without venting.  I understand not actually
speaking with the person can create difficulties.  I will
have to call MS and make an over the phone case or make an
internet case.  My thinking was that since CurrentDB.Name
returned the directory and name there must be an easy
command I have overlooked to tell the date an mdb or mde
file was created or modified.

I did get a response from a different posting saying to
put it in a shared hidden directory.  I did not know you
could open a mdb or mde in a hidden directory.

This is an incredible service.  I must say that I probably
have spent approx $5,000 over the last 2 years on cases
with MS but that is really ok because I would not ever get
anywhere without all the services...especially this one.

Thanks and keep up the good work.  

Steven.
Tim Ferguson - 21 Jun 2004 17:06 GMT
>  My thinking was that since CurrentDB.Name
> returned the directory and name there must be an easy
> command I have overlooked to tell the date an mdb or mde
> file was created or modified.

Often the simple questions don't have simple answers.

You can use the Scripting.FileSystemObject -- the File object in its
heirarchy has DateCreated, DateLastAccessed, and DateLastModified
properties.

Try (this has _not_ been tested!!):-

 Set fso = New Scripting.FileSystemObject

 Set fil = fso.GetFile(CurrentDB().Name)

 dt = fil.DateCreated

 Debug.Print Format(dt, "dd/mm/yyyy")

Hope that helps

Tim F
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.