MartyConnelly
martyconnelly at shaw.ca
Fri Dec 12 14:29:48 CST 2003
In Access 2003 Beta 2 in the database window the created and modified date look okay I seem to remember this as a problem in Access XP However if you run this code below in Access 2003, there is no difference between Date Created and LastUpdated Date. It never seems to change the lastupdated date. CloseObject "Modules", acModule 5 Module1 12/12/2003 9:52:09 AM 12/12/2003 9:52:09 AM 5 Module2 12/12/2003 10:21:07 AM 12/12/2003 10:21:07 AM 'sample call 'CloseObject "Modules", acModule Function CloseObject(strContainerName As String, intContainerType As Integer) 'From the Developer Solutions database 'Close open database objects of the specified type Dim dbs As Database Dim ctr As Container Dim intX As Integer Set dbs = CurrentDb Set ctr = dbs.Containers(strContainerName) For intX = 0 To ctr.Documents.Count - 1 ' DoCmd.Close intContainerType, ctr.Documents(intX).Name Debug.Print intContainerType, ctr.Documents(intX).Name, _ ctr.Documents(intX).DateCreated, ctr.Documents(intX).LastUpdated Next intX End Function Heenan, Lambert wrote: >x-posted to Access-D and Access-L > >Access 2002: I just noticed that if I make any change to any module in >Access 2002 then *all* the other modules have their modified date changed as >well as the one that really was changed. > >This is a major pain in the neck as now I have to keep a manual record of >what modules I just changed in my development copy so I know what to export >to the production copy. > >Is it just me???? ;-( > >Lambert > > > -- Marty Connelly Victoria, B.C. Canada