What is the way for finding out whether a table exists in the Microsoft Access database?

Anonymous User350117-Nov-2012

Hi Guys
Can someone tell me what is the way for finding out whether a table exists in the Microsoft Access database?

Thanks

ms access

Updated on 03-Dec-2012

Anonymous User

I am a content writter !

Can you answer this question?

Answer

2 Answers

Anonymous User

03-Dec-2012

This is solve my problem!
Thanks Avadhesh

AVADHESH PATEL

18-Nov-2012

hi ashish,

given query solve your problem....

Dim db As Database
Dim i As Integer
    Set db = DBEngine.Workspaces(0).Databases(0)
    fExistTable = False
    db.TableDefs.Refresh
    For i = 0 To db.TableDefs.Count - 1
        If strTableName = db.TableDefs(i).Name Then
            'Table Exists
            fExistTable = True
            Exit For
        End If
    Next i

forum

What is the way for finding out whether a table exists in the Microsoft Access database?

Anonymous User

2 Answers

Liked By