---
title: "What is the way for finding out whether a table exists in the Microsoft Access database?"  
description: "What is the way for finding out whether a table exists in the Microsoft Access database?"  
author: "Anonymous User"  
published: 2012-11-17  
updated: 2012-12-03  
canonical: https://www.mindstick.com/forum/468/what-is-the-way-for-finding-out-whether-a-table-exists-in-the-microsoft-access-database  
category: "ms access"  
tags: ["ms access"]  
reading_time: 1 minute  

---

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

Hi Guys\
Can [someone tell me](https://www.mindstick.com/forum/34097/can-someone-tell-me-what-is-the-most-effective-optimization-on-page-optimization-or-off-page-optimization) what is the way for finding out whether a [table](https://www.mindstick.com/articles/43918/how-to-design-table-using-bootstrap) [exists](https://www.mindstick.com/forum/158947/how-do-you-use-the-exists-operator-to-check-for-the-existence-of-records-in-a-subquery) in the [Microsoft](https://www.mindstick.com/articles/12301/microsoft-is-trying-to-kill-passwords) [Access](https://www.mindstick.com/articles/12994/how-foreigners-can-access-blocked-websites-in-china) [database](https://www.mindstick.com/articles/12226/use-of-database-in-sencha-extjs-and-insert-record-from-user-form-using-ajax)?\
\
Thanks\

## Replies

### Reply by Anonymous User

This is solve my problem!\
Thanks Avadhesh

### Reply by AVADHESH PATEL

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


---

Original Source: https://www.mindstick.com/forum/468/what-is-the-way-for-finding-out-whether-a-table-exists-in-the-microsoft-access-database

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.