<div>
Hi LSMconsulting,<br />
I am connected to &quot;Homer&quot; and the full code is below.<br />
I am however unable to export mannually, is 2000 to 97...<br />
Is there a way around this?<br />
<br />

<pre><code id="code-314707">DoCmd.TransferDatabase acExport, &quot;Microsoft Access&quot;, &quot;\\Homer\Analytics\International\Minotaur 97.mdb&quot;, acTable, &quot;BaseRateDailyTBL&quot;, &quot;BaseRateDailyTBLB&quot;, False, False
</code></pre>
</div>


Hi LSMconsulting,
I am connected to "Homer" and the full code is below.
I am however unable to export mannually, is 2000 to 97...
Is there a way around this?



DoCmd.TransferDatabase acExport, "Microsoft Access", "\\Homer\Analytics\International\Minotaur 97.mdb", acTable, "BaseRateDailyTBL", "BaseRateDailyTBLB", False, False


<div>
Ok have now found a way around by using a MakeTable query in the 2000 which builds the table in the 97. THanks for your help Martywal
</div>


Ok have now found a way around by using a MakeTable query in the 2000 which builds the table in the 97. THanks for your help Martywal

<div>
&lt;I am however unable to export mannually, is 2000 to 97...&gt;<br />
<br />
That would have been good info to add to your original post ... glad you got it fixed!!
</div>


<I am however unable to export mannually, is 2000 to 97...>

That would have been good info to add to your original post ... glad you got it fixed!!

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
I'm having a problem with a TransferDatabase acExport piece of code that when it runs just seems to delete the destination table from the destination database. The code is as below. I am getting the following VB error: Run Time 3011, Microsoft Jet unable to find the object. Any ideas much appreciated.<br />
THanks<br />
Martywal<br />

<pre><code id="code-314692">DoCmd.TransferDatabase acExport, &quot;Microsoft Access&quot;, &quot;\\Homer\Analytics\International\Minotaur 97.mdb&quot;, acTable, &quot;BaseRateDailyTBL&quot;, &quot;BaseRateDailyTBLB&quot;
</code></pre>
</div>
</div>


Hi Experts,
I'm having a problem with a TransferDatabase acExport piece of code that when it runs just seems to delete the destination table from the destination database. The code is as below. I am getting the following VB error: Run Time 3011, Microsoft Jet unable to find the object. Any ideas much appreciated.
THanks
Martywal

TransferDatabase acExport Problem

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.