I have a process that I need to archive past audits of servers. Rather than archive them within the current database, I have created an archive database to copy the past audit tables to.
Issue is that I need to have the user run the CopyObject macro from a command from the main switchboard and have a message box come up to allow a user to name the table to archive. Right now, I have the "New Name" field in the macro empty. I don't want users to access this due to security and to make this process as streamline as possible.
Since I am not highly versed in VB scripting, I do not know how to create a script to do this.
Anybody have any ideas?
Thanks in advance!