rename twice

[slimjen]

All, using access 2010. I have this code below to open backend and renaming a tbl with the current date. Ex. tblMstr to tblMstr20140922. This is so a table with the same name can be imported. tblMstr. This works great. My problem is when users have to reimport the same day they get something like “tblMstr20140922 already exist.” How do I fix this? If the same date already exist; I need it to override or something. Anyone have any suggestions to fix this please?

Dim dbBackend As DAO.Database
Dim strBackendDatabase As String
  strBackendDatabase = "C:\TestFolder\Sampledb.accdb"
  Set dbBackend = OpenDatabase(strBackendDatabase)
dbBackend.TableDefs("tblMstr").Name = "tblMstr" & Format(Date, "yyyymmdd")
  dbBackend.Close
  Set dbBackend = Nothing

[ranman256]

Dont use tables with date names. It makes the queries useless.
DO contain a date stamp in the table to show the data date...(irrelevant to queries)
Do put a date on the db name to archive it. The queries will still work this way too.

[slimjen]

I apologize for the misunderstanding. The date is to archive the file. No to use in the query. It’s just that the user may have to archive a table twice due to an error the first time in one day. So what do I do if this happens and the file already has a file with the same date? Thanks