<div>
Before I delete the object, how can I verified if the object is there
</div>


<div>
I'm not sure why you deem it necessary to verify that the object exists before deleting it, the code will only delete existing objects. But if you want to verify that it exists, this should do the trick:<br />

<pre><code class="code-10 nolinks" id="code-20-41505681-1"><span>    Dim tdf As DAO.TableDef</span>
<span> </span>
<span>    DoCmd.SetWarnings False</span>
<span>    For Each tdf In CurrentDb.TableDefs</span>
<span>        If tdf.Attributes And dbAttachedODBC Or tdf.Attributes And dbAttachedTable Then</span>
<span>            If tdf.Name = &quot;Name of your Table&quot; Then</span>
<span>                DoCmd.DeleteObject acTable, tdf.Name</span>
<span>            End If</span>
<span>        End If</span>
<span>    Next</span>
<span>    DoCmd.SetWarnings True</span>
<span>    Set tdf = Nothing</span>
<span>    Set db = Nothing</span>
<span></span>
<span>                                          </span>
</code></pre>
</div>


<div>
Try WinSQL. It is actually a database tool. It will help you in many ways. I always use it for such problems. it is compatible with any database and environment.
</div>


<div>
<div class="content wysiwyg-content">
Delete tables in a backend database<br />
and then import thoses tables from an other database.<br />
<br />
Example:<br />
<br />
On click button in the frontend databaseA:<br />
1- delete tables 1 to 20 located in the backend databaseA<br />
2- import tables 1 to 20 from c:\data\ databaseB<br />
<br />
How can I do it by VBA?<br />
<br />
Thanks
</div>
</div>


Delete tables in a backend database
and then import thoses tables from an other database.

Example:

On click button in the frontend databaseA:
1- delete tables 1 to 20 located in the backend databaseA
2- import tables 1 to 20 from c:\data\ databaseB

How can I do it by VBA?

Thanks

delete and import Access tables from an other access database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.