Anyone who could help would greatly appreciate it.



I get the error message "Cannot Update Database or Object is read only" 

when attempting to export the results of a query to an excel file using 

the following:



DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel97, 

ExportThisQueryToExcel, _

MyPathName, -1



The above is contained within a function which is called with one string

exportthisquerytoexcel the query name.



Mypathname is C:\etc etc but includes date and time so no to filenames can 

be the same.



I get the same error when trying to acheive the same result using a macro 

yet I have another database where a similar Do.Cmd works aok.



Whereas I have db.openrecordset statements in the calling sub i do not 

have any vb opendatabase commands at all. The database is not set as read 

only in win 98.



Regards



Mike