[AccessD] Locked Doc

[Martin]

Prob no use but a lot of time opening documents they open read only from
SharePoint. Add the save location as a trusted source?

What happens if you navigate to folder and open directly from word?

Check file properties in the file system.

Martin

On Thu, 2 Jun 2022, 17:23 Susan Harkins, <ssharkins at gmail.com> wrote:

> Is we to wd a typo?
>
> This probably won't help, but is there a Set wd = Nothing statement at the
> end?
>
> Susan H.
>
> -----Original Message-----
> From: AccessD <accessd-bounces+ssharkins=gmail.com at databaseadvisors.com>
> On Behalf Of Rocky Smolin
> Sent: Thursday, June 2, 2022 12:20 PM
> To: Access Developers discussion and problem solving <
> accessd at databaseadvisors.com>
> Subject: [AccessD] Locked Doc
>
> 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
>