Run time error '3027' Cannot update. Database or object is read-only

[Prasad via AccessMonster.com]

Hi,
We have been using an access application(*.mdb,in Access 97). working
properly. We need to install another s/w which needs oracle client 9i.
We figured out that, we need to upgrade our application to access2000.
I used convert option in access2000 to convert.
When I try to use this,
I'm getting the above error (in subject) at
DoCmd.transferText acExportDelim, , ToMoveTable, workfilename, True
Any help is greatly appreciated.

Thanks
Prasad

 

[Allen Browne]

The problem is with the value of workfilename.

The original A97 was clever enough to figure out that if you used
TransferText, it should create a text file. They dumbed it down. Now it
won't work unless the file name ends with a registered extension such as
..txt or .csv. And the error message is not very helpful to say the least.

If necessary, you can TranferText to a registered file extension, and then
use the Name statement to rename it.