Mulit User from linked to 1 source file

M

Mark Senibaldi

Hi,

I have 3 databases linked to the same .txt file for 3 different depts to
use. The problem is that if one dept has their database open the other depts
cannot open theirs and read from the same source file. This source file
cannot be split up and must remain 1 file. Can anyone please advise?

Thank you
 
A

Albert D.Kallal

You can't open text file in multi-user mode. Nor can ms-access.

Such a setup will not work, and is not going to be reliable even if you
could get it to work.

I would have the first user, or some process *read* in (import) the data in
the text file to a table if you need multi-user access.
 
Top