Changing a tables name with VBA

[Thomas Olsen]

ALL,

I would like to change the name of a table dynamically
giving it the same name with the current date attached to
it..



Mytable to Mytable-10/23/20003


IN advance thanks for your help..

Thomas Olsen

 

[Wayne Morgan]

Using your current example:

DoCmd.Rename "MyTable-" & Format(Date, "Short Date"), acTable, "MyTable"

 

[Tom OLsen]

Wow not too easy!!!!!! Sorry to bother
you!!!!!!!!!!!!!!!!