linked text file in access locked
Posted on 2012-03-12
I have a log file that gets updated by another process (excel) on a random time - whenever user does something in the excel file.
I want to link the table in the access database and read from it to do some additional analysis. But I noticed that if I have the file open in access, it locks the file from being able to update through excel. Is there any way around this so that I can have excel update the files even when its being opened by access?
Basically I just need it to read the file from access, and give a write access for the excel program.
OK... in the case where this isn't possible.... what is the simplest way to do an insert into access table from excel vba? Thanks!