Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 545
  • Last Modified:

TransferDatabase acExport Problem

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
DoCmd.TransferDatabase acExport, "Microsoft Access", "\\Homer\Analytics\International\Minotaur 97.mdb", acTable, "BaseRateDailyTBL", "BaseRateDailyTBLB"

Open in new window

0
martywal
Asked:
martywal
  • 2
  • 2
1 Solution
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Can you manually perform the Export without error?

Are you connected to the "Homer" network resource (that is, can you use Windows Explorer to navigate to that location)? If not, then Access won't be able to find your database and will error out.

Your TransferDatabase call is incomplete, but I presume that's a typo ... could you repost the entire call?
0
 
martywalAuthor Commented:
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

Open in new window

0
 
martywalAuthor Commented:
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
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
<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!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now