TransferSpreadsheet error - "object is read only"

[Jacqui3]

Hi,

When I attempt to use the Transferspreadsheet command I get the error message "object is read only".

The background is I had to have the database written to a CD to move it to a client site. When I copied the database off the CD I changed the file property to remove the read only indicator.

Everything else works fine except the Transferspreadsheet command.

 

[oharab]

Is the spreadsheet read only?
Not sure what else it could be if it's not.

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[thevillageinn]

i had a similar problem with a text log file. The extension was strange, and I was unable to import it into Acc 2k until I changed the file extension. Does your spreadsheet have a funny extension?

 

[Jacqui3]

I am using the Transferspreadsheet command to create a spreadsheet.

I managed to sort of resolve the problem. I moved the database to a new directory. Everything seems to be working for the moment.

 

[PizMac]

I also had the problem (on export) with strange file extensions. I include the code to create as .xls then rename to .cap (the strange one) - I'm sure you can adapt it for Import. Mine worked on some machines but not others (and so I assume there's some strange switch in either Access or Windows that I'm not aware of - does anyone know what?)

tempFile = "temp.xls"
WantedFile = "output.cap"
DoCmd.TransferSpreadsheet acExport, 8, "tableIn", tempFile, True, ""
Set fs = CreateObject("Scripting.FileSystemObject&quot
On Error Resume Next
' in case not there
fs.DeleteFile WantedFile, -1
' so can re-create
On Error GoTo 0
Name tempFile As WantedFile