Help with Access 2003 Database Macros

Hello, everyone.

Here is my situation. I need to create a backup of a table in Access once a month with a name using the previous month and year (mm/yy). I’m not quite sure which would be more appropriate to use-VB or a macro.

Here is the order I would like it to happen:

1. Copy a current table (tablename) with a new name referring to the previous month (yyyymmtablename).
2. Delete the data out of the current table (tablename) or create a blank copy of the backup table (yyyymmtablename).

Does anyone have any suggestions because I’ve been fooling around with some programming but I’m not sure what to do. Thank you.