I would like to have a macro in my Access 97 database to do the following:
Export tables to [CurrentUser].mbd
Where [CurrentUser] is the system variable.
Thus when user 256 executes this macro, each of the tables in the open database is exported to 256.mbd
