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

Question

Anonymous User · Answer

This is solve my problem!Thanks Avadhesh

AVADHESH PATEL · Answer

hi ashish,given query solve your problem....Dim db As DatabaseDim 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?

Can you answer this question?

2 Answers