title: MSAccess Link CSV file as a table on startup
body: <p>I struggle with a problem with linked tables to csv file.
  I did the attach by VBA code like this :</p>
  
  <pre><code>With CurrentDb
    Dim ts As DAO.TableDef
    Set ts = .CreateTableDef("cli")
    ts.SourceTableName = "CLI1.csv"
    ts.Connect = "Text;DSN=CLI1 Spec;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;DATABASE=C:\Users\user1\Desktop"
    .TableDefs.Append ts
    .TableDefs.Refresh
  End With
  </code></pre>
  
  <p>When this is called manually, the table is correctly attached.
  When this is called automatically inside the autoexec macro, I get an error 3625 saying that the text file specification "CLI1 Spec" does not exist... throught it does !</p>
  
  <p>Maybe it is because when running an autoexec macro the context is not fully initialized... but what can I do to have it work ?</p>