I have my projects set up to Export multiple tables to Access. The problem I am having, is that if someone in the company has the Access DB open, and runs the batch file to export.....the table is locked and will not export to that table. If I was doing this manually, I usally 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?