Mulitple users can not access a linked txt file

G

Guest

I have created a database that has a txt file linked to it. Only one user at
a time can access the linked file through a query or open on the file.
Nothing is locked, everything is shared. Any ideas?
Thank You :)
 
M

Mike Labosh

I have created a database that has a txt file linked to it. Only one user
at
a time can access the linked file through a query or open on the file.
Nothing is locked, everything is shared. Any ideas?
Click to expand...

Import it. Access is flaky where linked "files" are concerned. I can still
feel the pain from trying to get Access to do the same thing with a linked
FoxPro DBF.

If the file gets replaced or updated by some other external thing, then when
you import it the first time, save the "IMEX Specification" and then you can
write a little VBA that replaces your Access table with the contents of the
fresh file using the TransferText method.
--
Peace & happy computing,

Mike Labosh, MCSD

"It's 4:30 am. Do you know where your stack pointer is?"
 

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

Linked Excel File won't update 1
Record-Locking remains open after closing 0
UNION OF SELECTED TABLES ONLY. 9
Best way to deploy Access read-only database that is linked to SQL tables 6
Linked SQL Tables don't report Cascading Updates and Deletes 2
#Num Error Linked Excel Table 1
Problem deleting a .txt file 6
.txt file locked by Access 2

Top