Hi chaps
I was wondering if anyone has experienced a similar problem before.
I have a script that exports a query to a text file. It is to a fixed length text file. Each time I run the script it fails with:
*************
Runtime error '3011'
The microsoft Jet database engine could not find the object outboundfile#txt'. Make sure the object exists and that you spell its name and the path name correctly.
*************
So if I create a file called outboundfile#txt' in the correct location and run the script again, it deletes the original and then comes up with the error again.
Below is my code, have I missed something?
***************************
Function make_outbound()
Dim diallerfile As String
diallerfile = "c:\dialler\outboundfile.txt"
DoCmd.TransferText acExportFixed, "exportdialler", "C01 DIALLER FILE", diallerfile
End Function
***************************
I was wondering if anyone has experienced a similar problem before.
I have a script that exports a query to a text file. It is to a fixed length text file. Each time I run the script it fails with:
*************
Runtime error '3011'
The microsoft Jet database engine could not find the object outboundfile#txt'. Make sure the object exists and that you spell its name and the path name correctly.
*************
So if I create a file called outboundfile#txt' in the correct location and run the script again, it deletes the original and then comes up with the error again.
Below is my code, have I missed something?
***************************
Function make_outbound()
Dim diallerfile As String
diallerfile = "c:\dialler\outboundfile.txt"
DoCmd.TransferText acExportFixed, "exportdialler", "C01 DIALLER FILE", diallerfile
End Function
***************************