Why is locking occuring?

[GordonRS]

I have a fixed length .txt which I am linking into a MS Access 2002 d/b.
My options are set to :
default open mode -shared
default record locking - no locks
Open database using record level locking is unchecked
the (datasheet) form is set to:
allow edits/deletions/additions - no
recordset type - snapshot
record locks - no locks
the text box objects are set to:
enabled - no
locked - no

I have no requery actions associated with any events at all.

My problem is that while the form is active I am unable to open the source .txt and if it is already open I cannot save it. There is obviosuly a lock occuring on the .txt object - how can I prevent it occuring?

thanks!

Gordon

 

[MarkK]

Linked text files are read-only. You cannot prevent this.
Type 'TransferText' into Access help for more on ways of dealing with text files.

 

[GordonRS]

Thanks for the reply. Read-only within Access is exactly what I want to achieve in the database but if this is true for .txt files that doesnt explain why the .txt file is locked when a form associated with the file is open.