Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    i have an access app that many people are using, and no major issues have occurred - except for one. This is a user with a new computer. when she clicks on the button 'Export Data' she gets the error 'Cannot find Installable ISAM'. No one else has reported the issue and I can't duplicate the issue.

    The VBA is:

    Code:
        DoCmd.OutputTo acTable, "RUGItemChangeTable", "MicrosoftExcelBiff8(*.xls)", FilePath & "MLRA\MLRA_Changes.xls", False, "", 0
        DoCmd.TransferText acExportDelim, , "EditMDS", FilePath & "MLRA\MLRA.txt", True
    Where FilePath is the letter drive for a specific USB drive.

    I suspect there's a config issue in her case since the machine is new.

    She is running XP SP 3 and Office 2003.

    Any ideas??

    TIA

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    Does this Knowledgebase Article help?
    Regards
    John



  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    It might, if I had the machine and could look for the files myself. but the user is not a computer person and is in another city. i don't see asking her to do file searches and registry edits as a solution. i was hoping a SP might be in order, but her machine is up to date. Since other people can run the app without problems, it is a config issue. But I am not going to direct her to do this sort of sleuthing.

    anyhow, thanks for helping!

  4. #4
    Star Lounger
    Join Date
    Mar 2010
    Location
    Winston-Salem, NC USA
    Posts
    69
    Thanks
    12
    Thanked 4 Times in 4 Posts
    When you install Microsoft Office there's an option to install additional components, such as ODBC drivers and so forth. This is a shot in the dark but perhaps she could put the installation CD back in and select the "add features" option and have her select all the options for Access to see if that gets things going.
    Do your part!!! Report SPAM to http://www.spamcop.net/

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    austin, Texas, USA
    Posts
    1,029
    Thanks
    0
    Thanked 0 Times in 0 Posts
    yeah I thought of that yesterday - when i go to Add/Remove Programs and select Change from Office, there's no option for ODBC drivers in the Access section.

Posting Permissions

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