Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 525
  • 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

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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