.txt file locked by Access

[R Phipps via AdminLife]

I have an Access database that is linked to a div.txt filelocated on a network server. The Access database works great!! My problem is only one person can open the linked table, allother users receive error 'The process cannot access the filebecause it is being used by another process.' I changed thediv.txt file on the server to be read only and still have thesame problem. If I have the file opened in Access, I cannotopen the .txt file in Notepad, I cannot copy the file, or doanything with it. I do not want Access to have exclusivecontrol over the div.txt file. I want Access to only read thefile. It is a very large file so I do not want to have to'import' the file each time I open the database.

 

[Albert D. Kallal]

Hum, as far as I know...text files are only single user.

There is no means for record locking, and controlling for multiple users. I
would not as a matter of course try and use a linked table to a text file
for production use.

Now, it is true that you don't need to "edit" the data..but I don't think
access can accommodate multi-users in the same file..regardless.

What you could do is import the text file into a mdb file..and then link to
that .

If you have to do this often..you could make some process that runs each
night and creates this mdb datafile on a daily basisc..and then link to
it...

 

[david epsom dot com dot au]

Because the file system views text files as fundamentally different
from other files, there may not be a way to 'link' to a 'text' file
as shared.

It is possible that sharing is not supported by the file
system for files opened as 'text'. Since the text IISAM opens
text files as 'text', it is possible that there is no way to
link to a 'text' file as shared.

(david)


I have an Access database that is linked to a div.txt file located on a
network server. The Access database works great!! My problem is only one
person can open the linked table, all other users receive error 'The process
cannot access the file because it is being used by another process.' I
changed the div.txt file on the server to be read only and still have the
same problem. If I have the file opened in Access, I cannot open the .txt
file in Notepad, I cannot copy the file, or do anything with it. I do not
want Access to have exclusive control over the div.txt file. I want Access
to only read the file. It is a very large file so I do not want to have to
'import' the file each time I open the database.