How to check if a Table exist on Microsoft Access using VBA

In order to check if a Table exist on a Database (MS Access), we can use Function in VBA. Its pretty simple and I think most of you can easily learn and apply this on your own project. The idea of this function on this tutorial is to check if a table exist by typing the table name on a Textbox. See my project example here.

check if table exist

Now, here is the code. This code will be executed when Check Table button is pressed to check if table name on the text box exist in the database.

[codesyntax lang=”vbnet”]



check if table exist vba


Leave a Reply

Your email address will not be published. Required fields are marked *