Problem with Export to CSV file

[trifest]

I have the following code

DoCmd.TransferText "qrySelectExport", "f:\inventory\apinvExport.txt"

I can export once ok but when i try to export immediately again it says the following error. "The microsoft Jet Database engine cannot open file ". It is already opened exclusively by another user, or you need permission to view it's data." It creates an export.ini file but I cannot get it to export unless i rename it to something else such as apinvExport1.txt. Any clues on this? Thanks for the help.

 

[vbajock]

Sounds like the file is still open. If you delay writing the second file for a few minutes instead of doing it immediately, does it work properly then? Is the CSV file exceptionally large?

 

[trifest]

the file is not large at all 1kb. if i wait it still makes no different. the file is not open when i do it again. it's creating a schema.ini file too that if i delete it's fine.

 

[vbajock]

I think it is your syntax. Check the help file.
Here is the example they give, if you are using Access XP, I believe 2000 is the same:

DoCmd.TransferText acExportDelim, "Standard Output", _
"External Report", "C:\Txtfiles\April.doc"


Docmd.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage)

so yours should look like

DoCmd.TransferText acExportDelim, "MySchema","qrySelectExport", "f:\inventory\apinvExport.txt"