This content has been marked as final. Show 2 replies
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?