Hey guys,
I am writing a C# program that accesses my Access DB.
What is the SQL query that figures out whether a certain table exists in the DB?
Thanks
Hey guys,
I am writing a C# program that accesses my Access DB.
What is the SQL query that figures out whether a certain table exists in the DB?
Thanks
I don't know about doing this in SQL but this is how I would run a check in VBA.
Set tblDefs = CurrentDb.TableDefs
For Each tblDef In tblDefs
If tblDef.Name = "YOURTABLE" Then
End If
Next tblDef