When Deploying the project, you get an error message that contains "There is already an object name 'table name' in the database."
Applicable text of error message is:
... There is already an object named 'table name' in the database...
Find the database that contains the table in the error message. In the case above, we were Deploying the Staging database, so you'd want to open the Staging database node of the project.
Right-click on the database, go to Advanced, and select SQL Database Cleanup Wizard.
The SQL Cleanup Wizard will then run.
If there are no objects to clean up you will get a message saying there was nothing found.
If the Cleanup Wizard does find objects, a window will open and you will have the option of dropping objects. We recommend Right-Clicking the Project Header and selecting the Drop option.
Once you've dropped the objects, Deploy and Execute the database.
After following these steps, if you continue to get this error, you may need to recreate the database from scratch. If this is something you need assistance with, please contact the Jet Global Support Team.