When trying to setup an ODBC data source to a text file, receiving an error that says, ‘Can’t update. Database or object is read-only’. The file is a text file with no file extension on it.
This is a security feature of the Microsoft Jet ODBC Text driver. The ODBC driver only allows you to read files with the following extensions.
txt
csv
tab
asc
htm
html
If the file has any other file extension, or has no file extension, you will receive this error.
