how can I check to see if a table exist in my database and if it doesn't perform this action, if it does, don't do anything? This is my code and I only want to perform this action once.

VB Code:
  1. 'this code modifies the existing database without overwriting user data

  2.     'create new table

  3.     Call CreateConnection(objConn)

  4.         objConn.Execute "CREATE TABLE TempDocAudio(n_id  TEXT(50))"

  5.     Call CloseConnection(objConn)

  6.     

  7.     'modify Documents and Campaign tables

  8.     Call CreateConnection(objConn)

  9.         objConn.Execute "ALTER TABLE Documents ADD COLUMN n_mp3 TEXT(50)"

  10.         'cannot use default parameters with ODBC connectivity must switch to OLEDB

  11.         objConn.Execute "ALTER TABLE Documents ADD COLUMN n_wavBol TEXT(50)DEFAULT FALSE"

  12.         

  13.         'add wespak and defender columns

  14.         objConn.Execute "ALTER TABLE Campaign ADD COLUMN c_wespakOn TEXT(50)DEFAULT 1"

  15.         objConn.Execute "ALTER TABLE Campaign ADD COLUMN c_defenderOn TEXT(50)DEFAULT 1"

  16.     Call CloseConnection(objConn)