Table Exist

[Dominic Vella]

How do I check if table 'Company Details' exists before I start using it?

Thanks

 

[John W. Vinson]

How do I check if table 'Company Details' exists before I start using it?

Thanks

Using it in what context? VBA code? writing a query? building a form?

 

[Dominic Vella]

Oh, you are good!!

Dom

If DCount("*","msysobjects","name='Company Details' and type in (1,6)")>0
Then
MsgBox "table already exists"
Else
MsgBox "table doesn't exist"
End If


Chris
Microsoft MVP