[AccessD] Locked Doc

[Rocky Smolin]

He said "We were using wd.FileSaveAs  Path/Doc name" so  I asked him if
that was working. He said yes.  So I asked him to revert to that and see
what happens (this is too easy). He said he'd try and get back to me.

But I think your idea of VBA still having a lock on it could be the reason.
And Susan's suggestion of setting wd = nothing might release that lock.

We'll see.

r

On Thu, Jun 2, 2022 at 1:47 PM Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>