xml export error

[Frank]

Hello!

When I execute this -

DoCmd.TransferText acExportHTML, , "tblCOTClaim", "C:\temp\COTClaim.xml", True

I get -

Runtime Error '3027' Cannot update. Database or object is read-only.

Can anyone please tell me what I am doing wrong?

Thanks in anticipation!

 

[Douglas J. Steele]

Try using a different extension (try .txt). If that works, you can always
rename the file:

DoCmd.TransferText acExportHTML, , "tblCOTClaim", "C:\temp\COTClaim.txt",
True
Name "C:\temp\COTClaim.txt" As "C:\temp\COTClaim.xml"

 

[Frank]

Yes ... that worked (but I don't understand why?) ... Thank you ... the
resulting file is marked-up in html ... I need to write an xml formatted file
.... I can do so from the File > Export menu ... can I do so through code? ...
Regards ...

 

[Douglas J. Steele]

It worked because Access has entries in the registry marking only certain
extensions as valid for updating.

See http://support.microsoft.com/kb/245407 and
http://support.microsoft.com/kb/239471

 

[Frank]

OK ... I see ... Thank you ... Are you able to help with my question about
exporting in XML format using VB4A (I now realise I'll have to give the file
a .txt extention and then change it after)?