Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2002
    Posts
    1,245

    Unanswered: Unexpected Error from External Database Driver (MS Access Linked Table)

    OS: Windows XP (SP2)
    App: MS Access 2003 (SP2)
    DB: MS SQL 2000 (SP4, 2040)

    User is using MS Access linked table to query database (using ODBC). User can open the query in MS Access. However when the user goes to export the data to MS Excel format, the user receives the error message:

    "Unexpected Error from External Database Driver (22)."

    A trace on the db, reveals that the user process is attempting to log in to the server as 'Admin'. However, when the query with the linked table is first opened, the user is prompted for username/password (non Windows authentication).

    Any ideas? I googled and found some stuff, but nothing directly related and most of what I found was supposedly fixed with SP1.

    Any help appreciated. I am not an Access guru.

    Regards,

    hmscott
    Have you hugged your backup today?

  2. #2
    Join Date
    Dec 2002
    Posts
    1,245
    Found it. One last detail that I omitted: the user had a new computer built for him.

    I don't know the precise relationship, but I simply deleted the old linked tables and built new ones.



    Regards,

    hmscott
    Have you hugged your backup today?

Posting Permissions

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