MailMerge Fails Cos' No Permission

S

Sim Poh

Hi All,
I have an ACC2k program split into front-end and back-end files, with
user-level security
through a workgroup mdw file. I have a procedure that populate a temp table
'tmpListing' and follows by code to perform mail merge with Word:

DoCmd.OpenTable "tmpListing", acViewNormal, acEdit
DoCmd.SelectObject acTable, "tmpListing", False
DoCmd.RunCommand acCmdWordMailMerge

The above works. However if I deselected all options under the StartUp and
restart the program the procedure fails at the point acCmdWordMailMerge is
called. The error msg indicates lack of permission to access the database
(even when I login with full permission)

Have I breached any rules or can the procedure be done in a different way?

Regards

Sim Poh
p/s I hope I can explain clearly
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top