Opening Word multiple times with linked text file.

[Don]

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

 

[Peter Jamieson]

Do you really need to export a text file at all? Word won't open such files
as data sources in shared mode, as you have discovered. But could you get
the data directly from Access (which can be set up to be shared) using a
table or query? Or perhaps even directly from SQL Server?