Link to a txt file

[ticotion]

Hi

I have a front end build in access 2003, where an underlying query is build on a table that is linked to a txt file on a network drive.
The problem is that when a user access the query he locks the path to the txt file so no one else can access the query until he does'nt use it any more. Is it possible to solve this problem?

br
Ticotion

 

[G37Sam]

Access locks the text file to maintain exclusive rights to it since it will be adding/editing/deleting. You'll have to open the txt file in a read-only manner (if possible) to avoid locking it.

 

[ticotion]

Hi Sam

Thank you for your quick reply. Do you know how to code it to open in a read only manner?

br
ticotion

 

[speakers_86]

This post says you can use the command line argument /ro with shellexecute to open as read only. I did not test it, but it should work.