I am trying to do a simple export of a table but I keep getting this error message:
Run-time error '3027':
"Cannot update. Database or object is read-only."
Code:
Dim varExportSpec As String
Dim varTableName As String
Dim varFileName As String
varExportSpec = "AAtblBankExport Export Specification"
varTableName = "AAtblBankExport"
varFileName = "C:\BankExport\" & varTableName
DoCmd.TransferText acExportDelim, varExportSpec, varTableName, varFileName
MsgBox "Export Successful.", vbOKOnly
Nothing else is open in the DB, just the form that I use to export. I don't have any other files in the folder path I am using.