title: ImportExportText error when using frontend - you cannot record your changes because a value you entered violates the settings defined for this table
body: <p>I created a Macro in MS-Access that calls a lot of queries. First, it does a lot of ImportExportText to read 50 text files and write them in a table. It works perfectly but it creates some ImportErrors because some lines of the text are not OK, but it doesn't matter.</p>
  <p>The file is too big and it's near the 2 gb limit, so I decided to split it in frontend and backend and it seems to solve all my problems, but when I run the Macro from the frontend, it says:</p>
  <p><a href="https://i.stack.imgur.com/5DfBi.png" rel="nofollow noreferrer">You cannot record your changes because a value you entered violates the settings defined for this table or list (for example, a value is less than the minimum or greater than the maximum). Correct the error and try again</a></p>
  <p>I suppose it's because it tries to create a table in the frontend and maybe it's not allowed. Could that be the problem? How can I solve it? I tried to create the ImportErrors table manually and I could do that, but the error still appears.</p>
  <p>So, if I use the text files in MS-Access file that is just one file (not frontend and backend) it works perfectly. But if I use them in the frontend-backend mode, it fails. How can I solve that?</p>
  <p>Thanks!</p>