Error 75 on PDF creation for only 1 user

[jazzy]

Error 75 occured. Path/File access error

I have to assume it has to have something to do with their local machine. the have Microsoft to PDF and FoxitPhantomPDF Printer. works for everyone else. they have runtime accde file. was thinking of putting Full Access on it and stepping through. file is saved to a OneDrive folder. UservenuePath is stored in a 'Linked' table.

DoCmd.RunCommand acCmdSaveRecord

Dim UserVenuePath As String
Dim strFilePath As String
Dim strReport As String


UserVenuePath = DLookup("[FilePath]", "tbl_SystemInfo", "[SystemInfoID] = 1")
strFilePath = UserVenuePath & "\Contracts\" & Format(Form_frm_Contract.DateofFunction, "MM-DD-yyyy") & "\" & Form_frm_Contract.DayTimeFunction & "\"
strFileName = Form_frm_Contract.NameonContract & ".pdf"


If FolderExists(strFilePath) = False Then
          Call MakeDir(strFilePath)
Else
          MsgBox "This folder already exists.", vbInformation, "Folder Exists"
End If


'First let's open the report
strReport = "rpt_Contract"
DoCmd.OpenReport strReport, acViewPreview, , "[ContractsID] = [Forms]![frm_Contract]![ContractsID]", acWindowNormal


'Now let's save the open report to .PDF
DoCmd.SelectObject acReport, strReport
DoCmd.OutputTo acOutputReport, strReport, acFormatPDF, strFilePath & strFileName, False, , , acExportQualityPrint
DoCmd.Close acReport, strReport


'Display Message
MsgBox "New file has created successfully in the new folder!", vbInformation, "VBAF1"

Thoughts

[Welshgasman]

Are they able to save anything in that location?

[jazzy]

Yes, including creating a pdf manually

[Micron]

Error has a lot of causes, none of which I can think of that apply to one user other than user permissions, and you seem to have eliminated that. Code should not run at all if it was a Trusted Locations issue, so likely not that either.

Suggest you step through the code and check variable values - even add Debug.Print to the code to see the path strings in the immediate window. One user may be doing something odd or a piece of the path isn't valid just for the one user.