[AccessD] Locked Doc

[Stuart McLachlan]

You asked the same thing on this list two days ago as "Fwd: Creating Word Doc in 
    Access"

I asked a couple of follow up questions but got no response:

<quote>.What does he mean by "try to bring it up"?  Is he activating in the VBA function or 
is he 
going to the location and trying to open it in Word?

Is he closing it in the VBA functionbefore trying to open it?

Sounds like the VBA function still has a lock on it.
</quote>


On 2 Jun 2022 at 9:20, Rocky Smolin wrote:

> Dear List:
> 
> I got the following from a client. I don't see anything wrong with the
> save statement but I'm not that familiar with Word automation.  Any
> ideas what's going on?
> 
> MTIA
> 
> Rocky
> 
> The problem I am having is when Access creates a letter, it then saves
> it to a predetermined location and THEN when I try to bring it up,
> word says it is locked by the person that created it... WTF
> 
> 
> 
> We were using we.FileSaveAs  Path/Doc name
> 
> Brad changed it to
> 
>      wd.ActiveDocument.SaveAs2 Filename:=FDN, FileFormat:= _
> 
>         wdFormatXMLDocument, LockComments:=False, PASSWORD:="",
> AddToRecentFiles _
> 
>         :=True, WritePassword:="", ReadOnlyRecommended:=False,
> EmbedTrueTypeFonts _
> 
>         :=False, SaveNativePictureFormat:=False, SaveFormsData:=False,
>         _
> 
>         SaveAsAOCELetter:=False, CompatibilityMode:=15
> 
> 
> 
> Now you can only open the document as a read only...
> 
> 
> 
> ?
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com