Results 1 to 3 of 3
  1. #1
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts

    Solved -- Error 2001 You Cancelled the Previous Operation --- NOT!

    Hey Y'all,

    I keep getting the message in the title when I run this code in Access 2010 32 Bit (fresh install) on Windows 8.
    Code:
     
         DoCmd.TransferDatabase TransferType:=acLink, _
                                 DatabaseType:="Microsoft Access", _
                                 DatabaseName:=zDBFullName, _
                                   ObjectType:=acTable, _
                                       Source:=zTableName(iTblCnt), _
                                  Destination:=zTableName(iTblCnt)
    This code runs just fine in Access 2003 and I've stepped through the code in debug mode and all the parameters are getting correct values but I keep getting the error. The code is set to Late Binding to make sure I get the proper library links. I'm out of Ideas.
    Last edited by RetiredGeek; 2012-11-14 at 11:05.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  2. #2
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts
    Mine works fine, so i'm no help

  3. #3
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,436
    Thanks
    372
    Thanked 1,457 Times in 1,326 Posts
    Hey Y'all,

    Problem Solved. In my new Win-8/ Office 2010 Pro setup I forgot to setup the source file location which was on a network drive as a trusted location. Still getting used to the new security settings on Office 2010.
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •