Access Transfertext problems

[Ari]

Hello,


I'm creating an output file that will be uploaded to our ancient
mainframe. The output has to be in a specific order. I've created a
table and throughly tested the output specifications. I then did
file->export and was able to export it as a text file.


Now I'm trying to automate the exporting. I'm using this line:
DoCmd.TransferText acExportFixed, "TblOutput Export Specification",
"tblOutput", _
getOutputPath & "\output.ald", False


getOutputPath & \output.ald resolves to
:"\\CENTRAL\D2\HR\PAF\aldrecs\output.ald"
which I have all the required permisssions. I also have administrator
priveledges on the database and all tables. I can not find out why I
recieve the error:


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


Furthermore, I have read the help and:


The Database is not opened as Read-Only or attributed as Read-Only
The Database was created with the current version of access.
I have write permission on the folder.


If anyone can help me, I would appreciate it.

 

[TC]

Maybe the file already exists and TransferText will not overwrite it?

If that's not it, I'd try using normal file I/O statements
(open/write/close) to create a dummy version of the output file (ie. a
version woith arbitrary or no content). If /that/ didn't work, you know
you have a problem creating that file, for some reason unrelated to the
table & TransferText method.

If that doesn't help, try asking in an Access group. It's relly more of
an Access problem than a VBA one.

HTH,
TC

 

[George Nicholson]

Possible things to try:
1) Rather than exporting the table, create a query based on the table and
try exporting that. (That should rule out any table permissions or
table-in-use issues as the cause of the error).
2) Try using a .txt extension rather than .ald. (It shouldn't make any
difference, but since it's so easy to rule it out...)


HTH,

 

[Ari]

Actually, transfertext I found out won't export unless you give it the
..txt extension. I think that is so retarded.