Export fixed width file from Access 2003



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",

"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

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

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