+ Reply to Thread
Results 1 to 2 of 2

Unexpected error: An item with the same key has already been added.

  1. #1
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Unexpected error: An item with the same key has already been added.

    I'm using Excel v 1711 which has the ability to connect to a mysql database.

    When I log in to the database, I see a list of my tables, which is great. But when I highlight any table, I get "Unexpected error: An item with the same key has already been added."

    The only solutions I've tried so far are

    (a) to create a new workbook and go through the same steps. But that does not solve the problem.
    (b) to open the queries and connections to see if there were already any other such connections I had tried in the past. But nothing was there.

    I've googled the error but didn't see any posts involving Excel.

    The mysql database is hosted at AWS.

    Any advice? Thanks.

  2. #2
    Forum Contributor
    Join Date
    12-03-2008
    Location
    Key West, FL
    MS-Off Ver
    365 Apps for Enterprise
    Posts
    665

    Re: Unexpected error: An item with the same key has already been added.

    Solved. User Error!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Run-time Error '1004': An unexpected error has occurred
    By andywangrex in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-23-2016, 05:42 AM
  2. [SOLVED] Run-time error '1004': An unexpected error has occurred
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-15-2014, 05:54 AM
  3. [SOLVED] Unexpected error message
    By j_Southern in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-24-2014, 10:30 AM
  4. Replies: 4
    Last Post: 03-14-2010, 09:48 PM
  5. New to VBA, getting unexpected error 1004
    By Teodomiro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-04-2006, 11:50 AM
  6. If certain item is picked, then text added...
    By roger_home in forum Excel General
    Replies: 6
    Last Post: 02-12-2006, 06:39 PM
  7. How to make listbox show the last item being added?
    By Ai_Jun_Zhang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-31-2005, 12:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1