Error 3027


Nuno Gomes


I have a problem.

I have develop a program that works fine in some PC.
But in others PC's in the line "DoCmd.TransferText..." it occurs the error
3027 - "Can't update. Database or object is read-only"

In the code "DoCmd.TransferText" my destination file is "name.ap0". But if i
change to "name.txt" it works fine.
Does this make any sense?...

Thank you for all your help.

Nuno Gomes

Lord Kelvan

most likly because access cannot understand what the ap0 format means
what you could do is write a bit of code to rename the file one way
and then back again

something like

Name "C:\name.ap0" as "C:\name.txt"
'code to do what ever it is you want
Name "C:\name.txt" as "C:\name.ap0"

note your filepath may not be c:\

hope this helps


Nuno Gomes

Thank you kelvan for your response.

I've already do your sugestion and works fine.

But i can't understand why i don't have this problem in some PC's and in
others i have...

It's the same version of Access, the same OS and the access aplication is
local and running as local administrator... why this happens?!?!...

Nuno Gomes

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

Error 3027 1
MS Access error 3027 2
xml export error 4
Export to the Back End Folder 2
Export fixed width file from Access 2003 2
Run Time Error 3027 Database Read only message 2
Error 3027... 2
Error 3027 9