Mulit User from linked to 1 source file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Auto FE Updater Tony Toews Error Message 9
Permissions 2
Permissions Database 2
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Opinions on multi-user environment 5
Access 2002, multiple user access 14
Migrate mailboxes from one Microsoft Exchange Server to another Exchange 2
Access Switchboard error message 1

Back
Top