Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Automation error - object invoked has disconnected...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anyone help with Run time error -2147417848 (80010108) Automation error. The object invoked has disconnected from its clients.
    I am using Windows NT with Office 2000 connecting to Access from Excel using ADO.I have looked on the Microsoft Knowledge Base and artical q295549 seems to relate but refers to Windows 2000. I have tried setting
    objConn.ConnectionTimeout = 30 from the default of 15 seconds. Any ideas on best action to take or is there a patch?

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-10 01:34, Kevin Jones wrote:
    Can anyone help with Run time error -2147417848 (80010108) Automation error. The object invoked has disconnected from its clients.
    I am using Windows NT with Office 2000 connecting to Access from Excel using ADO.I have looked on the Microsoft Knowledge Base and artical q295549 seems to relate but refers to Windows 2000. I have tried setting
    objConn.ConnectionTimeout = 30 from the default of 15 seconds. Any ideas on best action to take or is there a patch?
    Have you looked for help with ADO, refer to the Help file, ADO210.CHM. The default location for this file is: "C:Program FilesCommon FilesSystemADO".


    Kind Regards,
    Ivan F Moala From the City of Sails

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Upgrade mdac to 2.6 or 2.7
    Microsoft Data Access Component
    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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