Date Created and Timestamps

N

nunyabizniz2399

New member
Local time
Today, 11:47
Joined
Aug 5, 2009
Messages
5
Is there any way to change the "date created" on any access file? I would like to permamently remove or change the date created? PLease help asap...:(:confused::eek:
 
Welcome to AWF!

I do no of a way to permanently remove or change the date created. The date is control by the OS. When you compact the databses, it will change tothe current date/time.


If we understand what you wanting to do, we may be able to help you come up with a solution. PLease explain in more detail what you are doing.

What do you want to change the data created to be?

Why do you care about the data created?
 
A different time on the same day or a different time and date. It doesn't really matter what time and day they are changed to...it just needs to be different than what they are now...
 
For Example, I have a file I am using that I created previously and I need to reuse. I do not want the same created date listed on the file when I reuse it. When I view Queries I have ran in access 2007 (under the "view by details" option) it lists the created date and the modified date. I would like for the created date or time to be changed.

Does this help?
 
Try this excellent free tool. It sets Windows file dates.
It is a good way to put the same date on all the files in a distribution.

But it can't change the creation dates on the objects inside the database.

http://setfiledate.en.softonic.com/

Pretty much everything in Windows can be done but perhaps this is one exception.
 
Last edited:
nunyabizniz2399 said:
For Example, I have a file I am using that I created previously and I need to reuse. I do not want the same created date listed on the file when I reuse it. When I view Queries I have ran in access 2007 (under the "view by details" option) it lists the created date and the modified date. I would like for the created date or time to be changed.

Does this help?
Click to expand...

Again, why do you care?

Note: A compact or compile can change the modified date. I have found them not a very reliable.

A simple fix may be to import the objects into a new database.
 
Found it.

DateCreated property of the tabledef and querydef. But they are read only.
 
I'm not sure what you mean by why do I care...I just need to change the created date on each access file and Query I ran.
 
Application.CurrentDb.QueryDefs(n).DateCreated

Run this code for a list of all the querydefs and their creation dates in the Immediate window.

Code: 
Dim db As Database
Dim m As Integer
Dim n As Integer
Set db = Application.CurrentDb
 
     m = db.QueryDefs.Count
 
     For n = 0 To m - 1
     Debug.Print db.QueryDefs(n).Name; " Created "; db.QueryDefs(n).DateCreated
     Next n
 
Perhaps it is possible to extract a tabledef or querydef and then save it. However the creation date is part of the definition of a stored object so the copy may also carry that date.

The only way I can think of to definitely redate these objects would be to recreate them.
Read every property using VBA and regenerate them from scratch using this information.
Use loops but make sure nothing is missed.

Could be done but sounds horrible. I would have to really want to change that date for a good reason.
No end user is ever going to see them anyway.

Incidentally the property for their saved date is .LastUpdated

You can manage the version of an object by testing these dates against a table of current release dates.
 
You must log in or register to reply here.

Similar threads

J
Creating ACCDE from ACCDB via GitHub or Azure DevOps Workflow – Any Experience?
Replies
14
Views
790
Josef P.
J
R
Using Outlook, Word and Access to send bulk emails.
2
Replies
22
Views
1,127
Silversee
S
R
Database inconsistent
Replies
9
Views
618
gemma-the-husky
gemma-the-husky
B
Splitting database
Replies
10
Views
473
The_Doc_Man
The_Doc_Man
C
Automated Production Planner
Replies
11
Views
695
GPGeorge
GPGeorge

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom