2 Replies Latest reply: May 15, 2014 9:51 AM by GailStevenson _ RSS

    Cannot open file. ... V6 Pro

    bill g

      I am trying to export multiple tables to Access. The problem I am having, is that I am trying to use the code: x = MonarchObj.JetExportTable(Filename, Table_name, Append_flag)

      in a module that is in the same .mdb file as the tables I want to export. The table is not being loaded and when I step through it in debug I get an error message, saying "Cannot open file. File may be locked or inuse by another application".

       

      Is there any way to set permissions to get around this problem?