1) Is this really VBScript or VBA?
2) the MDB format is basically depreciated, are you sure you want to store information in a format that may be discontinued sometime in the near future, MS has already yanked support for legacy thru ACC97-MDB files!
3) One way to do this in VBA would be to add a new database to the workspace then use a make-table action query against this new database against the open recordset or perhaps the
DoCmd.TransferDatabase depending on the nature of your application. A potentially faster method after creating a second database and setting up the table(s) might be the
SELECT.INTO Statement (Microsoft Access SQL) (syntax)) (personally I never build the SQL string in the function as shown in the example, makes it impossible to properly troubleshoot) and the execute method; however, I'm not sure if this will work as you've not included any details about your data source.
Lots of options here...
