View Full Version : Macro Export error 3027 (but works manually!)


emanresu
12-11-2006, 03:55 AM
Hi,
I have An Access app that has been moved from one domain to another and also converted from 97 to 2003.

A macro runs the TransferText command with the following arguments:
Transfer Type = Export Fixed Width
Specification Name = B123 (spec name does exist)
Table Name = CPB059
File Name = T:\reports\B123.FIL
Has Field Names = No

When it gets to this point execution stops with error 3027
"Cannot update Object or database is read only".

However, no files or folders are read-only, in fact access is full control.
Also, if I manually export a text file from that table it works! :confused:


Is this a bug or am I doing something stupid?

Appreciate any help you can give!

Thanks....

emanresu
12-11-2006, 05:14 AM
I have since read that it might be due to the file extension. i.e. I have to
give the file a "valid" file extension such as .txt so I will try that...

emanresu
12-11-2006, 05:51 AM
Success! :D