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.
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...