I am working in VB6 with and Access.mdb database.
I get a syntax error on the Alter Table query statement below. I have tried to change it but I cannot seem to beat the problem.
Using the .Open statement I have done selects/insert/drops/deletes and updates so that does not seem to be the problem.
Can you help me?
I get a syntax error on the Alter Table query statement below. I have tried to change it but I cannot seem to beat the problem.
Using the .Open statement I have done selects/insert/drops/deletes and updates so that does not seem to be the problem.
Can you help me?
Code:
dbImportDB.Open "dbImportDB"
rsNewCampaign.Open "ALTER TABLE " & Trim(strCampName) & " RENAME TO " & strHistTblName, dbImportDB, adOpenDynamic, dLockOptimistic