Table exists?

[liglin1]

Hi,
can anyone tell me, how to find out if a table in an MS Access DB exists?
Also, I'd like to find out, if certain columns exits if a table exists. Will
CREATE TABLE overwirte an existing table?

Thanks, Liglin

[Scott*e]

Hi,

Create table does not overwrite an existing table. You will get an error.

Not sure if the following will work in MS Access, but it works in MS SQL 2000

if exists (select 1
from sysobjects
where id = object_id('table_name')
and type = 'U')
BEGIN
drop table table_name
END

column names are similiar, you will have to look up the syntax yourself.

[CF_Oracle]

Why would you need this with Access database. Just open it in design mode and
see. It's not protected usually. If table exist you need rename it or delete in
order to use the same name for newly created. When imported table with the same
name it creates automatically new name with index. When exported it will
overwrite existing table with or without promt depending on your db settings.