Without your secret SQL, we can't tell much, but study this previous post on file attributes:
My access accdb file has in Properties / Details / Properies = Attributes = A trying to find out if that is why my SQL string does NOT stop saying
mark jackson
1
Reputation point
My access accdb file has in Properties / Details / Properies = Attributes = A trying to find out if that is why my SQL string does NOT stop saying field definition is bad as it works still in another dabase with same REFS