Read only Error on export

[njb]

I'm trying to export the results of a query to an Excel Spreadsheet. I have a macro that does Transfer Text with the following arguments: Export HTML, (no specification name), QryStatusAll (the name of my query), s:\Project Tracking\QryStatusAll.xls, Yes (has field names), (no HTML Table Name), (no Code Page). When I run the macro, I get a message box that says, &quot;Cannot update. Database or object is read-only. (Error 3027)&quot; This is Access 2000. The database and the file folder are in a shared directory on a server. I can successfully run this macro from my desktop with no errors. I get the error when I run it from my supervisor's desktop. The only difference is that he is running Windows 2000, and I am running Windows 95. We also have individual versions of Access running. Also, I can successfully &quot;manually&quot; export the file from either of our desktops by running the query, clicking File, Export, choosing the file folder on the shared drive to Save in, using the name of the query as the File name, Save as type .xls, checking Save formatted, and Save. The file gets written out just fine. I also tried to export it with the macro from another workstation with Windows 2000, and it didn't work there either. Any ideas?<br><br><br><br>

 

[rbowes]

Is this a secure database that establishes read-only permissions?&nbsp;&nbsp;How is the database shared? If the tables being used are linked to a back-end, there may be a problem with exporting from the macro.&nbsp;&nbsp;Have you tried the TransferSpreadsheet method instead of TransferText?&nbsp;&nbsp;I'm not sure what the problem is, but there seems to be a permission problem and it could be in your security.&nbsp;&nbsp;Let me know.<br><br>Bob B.

 

[Guest_imported]

I actually got this to work.&nbsp;&nbsp;I changed two things and I'm not sure which did it.&nbsp;&nbsp;The first thing was changing the registry so that <br>HKEY_lOCAL_MACHINE\Sortware\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions included xls<br>This was reported in the 4/2000 edition of the MSDN Library<br><br>At the same time I verified that the References were the same.&nbsp;&nbsp;One of them was not.<br><br>I had a module that did TransferTexts for several different queries.&nbsp;&nbsp;It ran the first time, but the second time, it got through a few of them, then quit.&nbsp;&nbsp;I found that if I shortened the names, it would work a second time.&nbsp;&nbsp;I also found that if I deleted all of the files that were created before running the module it would work.&nbsp;&nbsp;So it seems that there is an Office 2000