[AccessD] Access 2002 - module modified dates all changing at once.

Heenan, Lambert Lambert.Heenan at AIG.com
Fri Dec 12 14:49:20 CST 2003


Ah Hah!!! So it's actually a conspiracy to get us all to upgrade to Access
2003. <g>

Lambert

> -----Original Message-----
> From:	MartyConnelly [SMTP:martyconnelly at shaw.ca]
> Sent:	Friday, December 12, 2003 3:30 PM
> To:	Access Developers discussion and problem solving
> Subject:	Re: [AccessD] Access 2002 - module modified dates all
> changing at once.
> 
> 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
> 
> 
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


More information about the AccessD mailing list