Check if table exits before delete query

[Dan2kx]

Hello, me again

i am creating tables (and deleting them) based on the Public variable StaffID the reason for this is the information used in these tables is used to display staffing information and needs to be viewable on multiple terminals, so i am creating the tables with " & LogStaffID & " infront of the table/query name, but as to not clutter up the database i am deleting the tables on unload of the form, but to avoid errors i wonder if there is an if command i could use to check the table exist

such as

if "" & LogStaffID & "TableName" exists then do delete query

do create query

thanks if ya can help

[jaxjagfan]

Hello, me again

i am creating tables (and deleting them) based on the Public variable StaffID the reason for this is the information used in these tables is used to display staffing information and needs to be viewable on multiple terminals, so i am creating the tables with " & LogStaffID & " infront of the table/query name, but as to not clutter up the database i am deleting the tables on unload of the form, but to avoid errors i wonder if there is an if command i could use to check the table exist

such as

if "" & LogStaffID & "TableName" exists then do delete query

do create query

thanks if ya can help

Here is a function I used for cleaning up import error tables and should work for you as well. Attach the CleanErrors on the form Unload event.

Public Function CleanErrors()
 
Dim tname As TableDef
Dim db As Database
Dim tdef As TableDefs
On Error Resume Next
Set db = DBEngine(0)(0)
Set tdef = db.TableDefs
 
For Each tname In tdef
    If tname.Name Like "*" & LogStaffID & *" Then
    DoCmd.DeleteObject acTable, tname.Name
    End If
Next
 
End Function