Problem With Make-Table Query

[rwharris]

I am new to Access, the 2007 version. In my current project, I would like to be able to make a copy of a table. This can, of course be done with copy-and-paste but I would like to automate the process. I had the idea of using a Make-Table query in which all records are selected from the source table and copied to the destination table. The problem is that, insofar as I can see, the destination table name is "hard-coded" within the query. My project is going to require making a copy of the table on a daily basis. I would like for the project to prompt for a destination table name before making the table. I can't figure out how to do this. I thought about the use of TempVar but I can't figure out how it would work. Any suggestions would be qreatly appreciated.

Robert Harris

[jrickels]

You could prompt the user in vba:

Public Sub CopyTable()
Dim answer As String
Dim sql As String
answer = InputBox("What would you like to name your table?", "Table Name")
sql = "SELECT OriginalTable.* INTO " & answer & " FROM OriginalTable"
DoCmd.RunSQL sql
End Sub