[AccessD] A2003: rename a file via vba

On 17 Dec 2004 at 12:40, Darren DICK wrote:

> Hello all
> Any suggestion on renaming a file via code
> PSEUDO CODE EXAMPLE
> 
> Some thing like
> Call Rename "C:\mydB.mdb", "C:\mydb" & "_" & Format(Date,"dd/mm/yyyy") &
> ".mdb"
> 

The "Name" command has been part of VBA since the year dot and was part of 
most flavours of Basic since the very early days. Just use:

Name "C:\mydB.mdb"  "C:\mydb" & "_" & Format(Date,"dd/mm/yyyy") & ".mdb"



-- 
Stuart