[AccessD] A2003: rename a file via vba

On 17 Dec 2004 at 14:09, Darren DICK wrote:

>  
> Hi Stuart
> Many thanks
> When I copy and paste the line below it errors, then goes red and tells me
> it is expecting
> Compile Error: Expected: As
> The Compiler then goes to the space after the first "C:\mydB.mdb"
> 
> Any thoughts??
> 


That's what you get when you do things from memory :-(

It should indeed be:

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




-- 
Stuart