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.
