Cannot Open Word Mail-Merge document from Access Switchboard

[SGTSweety]

Good day:

I'm attempting to open a mail-merge Word document from Access switchboard. Can run module from VBA window successfully, but Switchboard will not. Sometime, I get an error that the database is locked by me and wants a user name and password. It defaults the user name to 'Admin'. This database is intended for use by other users within the department.

Public Sub LTR_ExpireWarning()

Application.FollowHyperlink "G:\PUBLIC\REHAB\FORM_LTR_RehabsAboutToExpire.docx"

End Sub

The mail-merge uses data from a table in the database from which the switchboard is run.

I'm running 64-bit Windows 7. Office 2010, but the database is still 2003 version.

Thank you for your time.

Best regards
Steven

 

[1DMF]

What lock or access to the data does the switchboard have that might be locking the records the mailmerge wants?

I always mailmerge from an XLS spread sheet as the data source which is output via a transferspreadsheet command against the data / query in question.

"In complete darkness we are all the same, it is only our knowledge and wisdom that separates us, don't let your eyes deceive you."

"If a shortcut was meant to be easy, it wouldn't be a shortcut, it would be the way!"
Free Electronic Dance Music