"Open as Copy" word doc from Access

[xentaur]

Dear Gurus

My Access 2000 DB project is used by a few operators at the same time. It launches Word letters through the access interface. Have discovered that when a user has a given letter open it will prevent other users from opening that same letter from the Access interface.

I've searched extensively through tek-tips and net-wide for a command line switch which will open the letters as a copy eg.

"C:\Program Files\Microsoft Office\Office\winword.exe" /openascopy "I:\AppPath\Letter.doc"

Any help greatly appreciated.

xentaur
---
If you get lumps in the ketchup, keep shaking the bottle

 

[PHV]

You may try something like this:
/tI:\AppPath\Letter.doc

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[xentaur]

Thanks PHV

This trick works well for excel but has no apparent effect on word documents.

Do you have any other suggestions?

Thanks


xentaur

 

[payback]

I have an application that lets the user select a letter template, copies it, then they open the copy and merge any data from their database.

It uses the VBA FileCopy command. Search in help for this but let me know if you need any other information.

 

[xentaur]

Thanks all for your assistance.

Have now learned that my issue is with the datasource table in Access 2000 being locked. Have to figure out a way to get word mailmerge to point to an environment variable like %TEMP%\TblMrgDoc.xls - have reposted in the office forum.

Thanks.

xentaur.