The easiest way is to execute a select command on the table.
If the following command raise exception upon execution, means the
table does not exist.
cmd.CommandText = "select top 1 * from demographs";
The hard way is to query the database schema. Try to google
"OleDbConnection.GetOleDbSchemaTable".
To drop the table, you will have to execute the command below:
drop table demographs
Do not include the "IF OBJECT_ID(....".
If the database can be anything else, why not use SQLCE which is a
client database and server is not required?