This is going to depend on what you've typed in the textbox, which we can't see. It's quite likely that the table name you've typed in isn't valid, and needs to be escaped by surrounding it with back-ticks.
createSql = "CREATE TABLE `" & TextBox2.Text & "` (CODE VARCHAR(25), PCID VARCHAR(25), Assigned_To TEXT, Deployed TEXT, PRIMARY KEY (CODE));"
If it still doesn't work, you'll need to debug your code and examine the query to try to identify the problem.