Opening Word multiple times with linked text file.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 09 Aug 2004 13:07 GMT

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

Reply to this Message

Peter Jamieson - 09 Aug 2004 23:11 GMT

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?

Signature

Peter Jamieson

> 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
[quoted text clipped - 16 lines]
>
> Don

Reply to this Message

Rate this thread: