Docmd.TransferText gives error ??

[Romanov]

When I use the following command in Access 2000 :

Docmd.TransferText acExportMerge,, "tablename", "c:\filename.doc", True, ""

I get an error message saing :
Cannot update. Database or object is Read-Only.

The exact same code is used in my Access 97 application and works fine. If I take the example from the help file in access I also get this error.

Can anyone help me on this ??

Romanov

 

[boblarson]

The only things I see in your code is that you aren't using an export specification file (which isn't required), and you shouldn't have "" at the end of True.

Try doing pulling the ,"" off of the end of your line and see if that helps.

BL
hth

 

[Romanov]

I tryed to remove the "" in the end of the code - that did't help. Then I tryed to put in a export specification file - that did't help either.

I tryed to build a new database with one tabel to export from, and that did't help either.

Any surgestion to what I can trye ??

 

[pcs]

this will sound stupid...but try changing the extension of the output file to .txt instead of .doc. and see if that changes anything...

al

 

[Romanov]

Hi Al,

Your surgesten sounded a little wild -- but then again... I tried it, and you now what - it works.

How cut I miss that ?. I have even tried without extension on the filename without look.

Thank you - you just saved my day.

br
Romanov

 

[pcs]

glad it worked...

we won't go into the reason why...another A2000 'improvement' from MS

al

 

[Rich]

Would it be wise now to start buying redundant copies of 97? I'm thinking now of the fortune I've lost by scrapping old cars over the years. Will old versions of Office become collectors items

 

[pcs]

-------you wrote-----
Will old versions of Office become collectors items
---------------------

like most things collectable, i think some versions will be more sought after.

ver. 1.0, 7.0 and 2000 will likely have no current or future market value.

al

--------------
rich,

on further thought...
will old programmers who have expertise in 'dead' languages ever have a market value as 'collectables'?
the Japanese do this with people with all kinds of skill sets. they are "living national treasures" and are provided for by the government.

just might be an option for me...

[This message has been edited by pcs (edited 01-06-2002).]