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

  • Thread starter Thread starter Prasad via AccessMonster.com
  • Start date Start date
P

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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transfertext Error - Database or object is read only 1
3027 cannot update. Database or object read-only 4
Can't update. Database or object is read only 1
Error 3027: cannot update: database or object is read only 4
Error 3027 - Db or object is Read Only 4
Run-time error '3027' 5
Run Time Error 3027 3
Run Time Error 3027 Database Read only message 2

Back
Top