[AccessD] A2003: rename a file via vba

Darren,

Look up 'Rename' in help.

This is the example they give:

DoCmd.Rename "Old Employees Table", acTable, "Employees"


HTH,
Dan Waters
ProMation Systems

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Thursday, December 16, 2004 7:40 PM
To: 'Access Developers discussion and problem solving'
Subject: [AccessD] A2003: rename a file via vba

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"

Many thanks

Darren

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com