Export fixed width file from Access 2003

  • Thread starter Thread starter Sreedhar
  • Start date Start date
S

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