Opening Word multiple time with linked text file

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

Guest

Hello, I'm using Access 97 to open a Word document that is a legal document
for my client. I'm using the merge feature in Word to insert certain data
stored in a SQL Server database that changes earch time the report is run. I
put a text file on the network that Word uses for the merge. The problem is
when a second person tries to open the same report. When I run:

DoCmd.TransferText acExportDelim, , "TableName", rs!Directory &
"\tmpLegal.txt", True

I get the following error message.

The Microsoft Jet database engine cannot open the file 'tmpLegal.txt'. It
is already opened exclusively by another user, or you need permission to view
its data.

How can you get around this message.

Thanks

Don
 
Hi Don,

It sounds as if the textfile is a temporary file generated for that
specific merge operation. In that case probably the best thing is to
create it on a local drive rather than on a network share, so each user
will have their own independent copy.
 
Back
Top