<div>
I did BTW go back and look at the schema.ini options and what I said was correct; if you link to a text file as a table, it's always opened read/write.<br />
<br />
Jim.
</div>


I did BTW go back and look at the schema.ini options and what I said was correct; if you link to a text file as a table, it's always opened read/write.

Jim.

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


Hi,

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!

linked text file in access locked

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.

Microsoft Access

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.