Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 399
  • Last Modified:

linked text file in access locked

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!
0
iamnamja
Asked:
iamnamja
  • 2
1 Solution
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
You'd have to open the file via VBA as read only.  There's no way I can think of to simply link to it and have it read only.  That's the way the text ISAM driver works.

Jim.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
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.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now