Export fixed width file from Access 2003

[Sreedhar]

Hi everyone !

I'm using Access 2003. I'm trying to export an Access table in to a fixed
width text file through VBA as follows:

DoCmd.TransferText acExportFixed, "GROUP_SPEC", "TempGroup",
strFileNameAndPath

"GROUP_SPEC" is the name of the fixed width specification and is very much
valid and so are the rest of the arguments, but I'm getting the following
error:

3027 : Cannot update. Database or object is read-only.

Can anyone please help me out ? thanks.

 

[JH]

If you are certain all arguements are valid, is it possible that you do not
have (network) administrative rights to that database and to the file you are
writing to?

I know that when I set up a shared database on my network, I almost always
set the general public rights to read-only.


Other than that, I'm not sure. Your function call looks like the correct
syntax.

 

[Sreedhar]

Hi,

i've found this which solved my problem:

http://support.microsoft.com/kb/245407/en-us