Results 1 to 3 of 3
  1. #1
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Converting A2k back to A97 (A97 SR-2)

    I have developed a database in A2k and had to convert to a previous version of Access (A97). First of all the switchboard blew up, I fixed that by copying another switchboard form form another database.
    Now I get a compile error on a TransferSpreadsheet command on the acSpreadsheetTypeExcel9 parameter.
    It's probably references, but I don't know which one.

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

    Re: Converting A2k back to A97 (A97 SR-2)

    The 9 in acSpreadsheetTypeExcel9 is the version number, corresponding to Excel/Office 2000; of course, this is not known in Access 97. Replace it by acSpreadsheetTypeExcel8 or acSpreadsheetTypeExcel97. (The value of all these constants is the same, since the file format for Excel hasn't changed)

  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Converting A2k back to A97 (A97 SR-2)

    Thanks Hans, I did not think of that at that stage of past by bedtime.

Posting Permissions

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