Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Export to Excel file (2003 SP2)

    I sent a runtime database to a Vendor who has office 2000 standard. The database exports a table to an Excel spreadsheet for return to me. When the Vendor tries to run the export procedure she receives an error that the file cannot be saved. Is this a version conflict? If so what are my options?
    Thanks
    chuck

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export to Excel file (2003 SP2)

    It is always dangerous to develop a database in a later version than the one the user has. VBA references tend not to be adjusted correctly. You should test a copy of the database thoroughly on a machine with Access 2000, then send that copy to the user without opening it in a later version in between.

  3. #3
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export to Excel file (2003 SP2)

    Actually, I was able to test the runtime on a machine with office 2000 pro, but not with office 2000 standard. That's how I found out the runtime disabled Access 2000 so every database opened in runtime. There was a service patch that fixed that.

    Thanks for your time.
    Thanks
    chuck

  4. #4
    3 Star Lounger
    Join Date
    Mar 2006
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    289
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Export to Excel file (2003 SP2)

    Gee whiz...I replied to myself. Fortunately, it was a simple error made when the folder was created. It works fine.

    Thanks again for your time. I really thought I had an issue here. Sorry.
    Thanks
    chuck

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Export to Excel file (2003 SP2)

    Thanks for posting back.

    (It doesn't really matter whether you reply to yourself or to me, I'll read the reply anyway)

Posting Permissions

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