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