I have the following in code
DoCmd.TransferText acExportDelim, , "qryMAS90APExportsSorted", "F:\Export\AP" & [Forms]![frmStartup]![txtBatchNumber] & char(39) & [Forms]![frmStartup]!txtCompanyNumber
It says that "Cannot Update. Database or object is read only"
but if i add .txt to the end of the filename it works. I'm working in Access 2002.
Could I possibly substitute the period in the file name with an ASCII representation so that the period is not explicitly placed in the nameing convention.
DoCmd.TransferText acExportDelim, , "qryMAS90APExportsSorted", "F:\Export\AP" & [Forms]![frmStartup]![txtBatchNumber] & char(39) & [Forms]![frmStartup]!txtCompanyNumber
It says that "Cannot Update. Database or object is read only"
but if i add .txt to the end of the filename it works. I'm working in Access 2002.
Could I possibly substitute the period in the file name with an ASCII representation so that the period is not explicitly placed in the nameing convention.