Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    44

    Unanswered: Transfer Text & Converting from 97 to 2000

    I designed a database in 97 but now need to convert it to 2000. All worked except one of my macros.

    It is a transferText, a query to a excel spreadsheet.

    I am now receiving an error:

    "Cannot Update. Database or Object is Read Only".

    Can anybody help me as to why this is not working.

    Thanks

    Smilla

  2. #2
    Join Date
    Dec 2003
    Location
    Toronto, Ont. Canada
    Posts
    238

    Re: Transfer Text & Converting from 97 to 2000

    Originally posted by Smilla
    I designed a database in 97 but now need to convert it to 2000. All worked except one of my macros.

    It is a transferText, a query to a excel spreadsheet.

    I am now receiving an error:

    "Cannot Update. Database or Object is Read Only".

    Can anybody help me as to why this is not working.

    Thanks

    Smilla
    Ummm... Question?...

    Why would you be doing a TransferText when the query results are going to an Excel Spreadsheet??... Try doing a TransferSpreadsheet instead...

    If you actually do have TransferSpreadsheet and you are getting an error, check the Excel format that it is exporting to... You probably have it exporting at an Excel 97 sheet instead of an Excel 2000...

    HTH

Posting Permissions

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