Hi there, I'm hoping someone can give me a hand figuring this out. I've done a lot of searches and looked through 4guys here, but can't seem to find an answer. I have a script which uses an Access db. What I want to do is create a function which will duplicate all tables and recordsets with all current data into new tables which have been renamed using a field in the db as a base. <BR><BR>eg TableName1, TableName2, etc. changed to somefield_TableName1, somefieldTableName1, etc. where the "somefield" is stored in the db somewhere or possibly passed along through a form.<BR><BR>Basically the outcome I'm looking for is to backup all current data in the database and keep all the current Tables and record data in place.<BR><BR>Any ides/suggestions/places I couldlook to read up on this?<BR><BR>Thanks for your help.