How can I retain the creation and modification dates of objects

[nagyf]

Consider the case that you have a damaged database but you can import its objects to a new empty one. In case of importing an object its creation date and LastUpdated property are set to the current time. Next day you see all objects having the same creation date (within the duration of the importing process), so you lose the information when you have really modified and created the modules, forms, so on.

How can I retain the creation and modification dates of the database objects when I import them?

Can I set these properties to a past date programatically?

I plan this solution:
1. Read the true system date and time.
In a cycle for each objects to be imported:
2. Read the modifiaction date of the actual object.
3. Set the system date back to the read date.
4. Import the actual object.
Repeat steps #2-4.
5. Reset the system date and time to its true value.

How can I do step #3?
How can I set the system date back to the value read in step#2 programmatically? Is there any Visual Basic object or an API call for date and time setting? [tt]
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"
[/tt]

 

[mp9]

Hmm, DateCreate and DateUpdate are stored against each object in MSysObjects but I'm not sure you can update them using SQL...

http://www22.brinkster.com/accessory/

 

[mp9]

Possible other fudge workaround: put the objects you want to retain info on in a Group (Favorites is fine). Then after compaction/repair although the dates on your objects are screwed the dates on the shortcuts in Favorites is unchanged.

NOTE: the shortcuts you create in a Group won't pick up the modified date for subsequently modified edits. Is this a problem?

http://www22.brinkster.com/accessory/

 

[nagyf]

What is that Group?
I know Groups as groups of users of workgroup administrator.

I simplify my question:
Which Windows API function sets the system date and time? [tt]
Ferenc Nagy
|\ /~ ~~|~~~ nagyf@alpha0.iki.kfki.hu Fax: (36-1)-392-2529 New!
| \ | | Institute of Isotope and Surface Chemistry
| \ | -+- 1525 Bp. POB 77. Tel. 36-1)-392-2550
| \| |

http://alpha0.iki.kfki.hu/~nagyf

`-' ' `-' "The goal of the life is the struggle itself"
[/tt]

 

[mp9]

This is an Access 2000 feature which allows you to group object together.

http://www22.brinkster.com/accessory/