Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    35

    Unanswered: ActiveX Componet Can't Create Object error

    When I try to use the "find duplicates query wizard" in my Access 2000, I get the error "ActiveX Component Can't Create Object!". I click the OK button and then get the error "Subscript out of range". I read in another post that someone had a similar error and said that their DLL wasn't properly registered, and I know our company has been doing a lot of security and software updates. Can anyone tell me how to fix this? Thank you EVER so much!

  2. #2
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    Hi

    Detect and Repair or a reinstall should sort it out. I don't know if anything less extreme can fix things.

    Query to find dups:
    Code:
    SELECT Col1
    FROM MyTable
    GROUP BY Col1
    HAVING COUNT(Col1) > 1
    HTH
    Testimonial:
    pootle flump
    ur codings are working excelent.

  3. #3
    Join Date
    Jun 2004
    Posts
    35
    Thanks for the info and I tried that but it didn't work. Its really odd. Another person was able to perform this task from their computer so it's obviously something on my pc. Anyone have any suggestions?

Posting Permissions

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