title: Create a 2003 .mdb file
body: <pre><code>Dim LFileName as String
  Applicaion.FileDialog(msoFileDialogSaveAs).InitialFileName = "\\filepath\\" &amp; Format(Now,"mm-dd-yyyy") &amp; ".mdb"
  If intChoice &lt;&gt; 0 Then
      LFileName = Application.FineDialog(msoFileDialogSaveAs).SelectedItems(1)
  End If
  
  If Dir(LFilename) &lt;&gt; "" Then Kill LFilename
  
  Set ws = dbEngine.Workspaces(0)
  Set db = ws.CreateDatabase(LFileName, dbLangGeneral)
  </code></pre>
  
  <p>This is "create .mdb file" code, and it works. The only problem is that after I transfer my tables over and everything, and then try to relink my frontend to the backend (this created db) it gives me this error: </p>
  
  <blockquote>
    <p>Microsoft Access dos not support linking to an Access database or Microsoft Office Excel workbook saved in a format that is a later version than the current database format</p>
  </blockquote>
  
  <p>BUT. If I take the newly created backend file (made with the vba code) and Save &amp; Publish > Microsoft Access 2003 .mdb format, then try to relink it, it works. Is it saving as a .accdb but with the .mdb suffix or something (?)</p>
  
  <p>So this makes me wonder if there's a way to specifically create a mdb 2003 format mdb with VBA? I've been googling this all day and I can't find anything other than the code above. Is there a way to word this question better?</p>
  
  <p>Info: I'm using Access 2010, but I have to use .mdb because some people in the office still use office 2007. I know office 2007 can use .accdb files, but it can't handle 2010 .accdb files for some reason.</p>