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
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