Access Project prompts for Access password when exporting

M

MNF

I am using ADP in Access XP to Output Report to html file
using command
DoCmd.OutputTo acReport, stDocName, acFormatHTML,
CurrentProject.Path & "\Overdue.htm", False

The problem is that before the export is done, Access
pops up the login box for the user to enter their username and
password. (I have Access security installed and running. Note that
this is the Access username and password as defined in the system.mdw
file and not SQL
security.)
The bigger issue is if I create ADE file from ADP, the OutputTo
command fails with "Access can't complete the Output operation".

It seems that OutputTo tries to save some information in the Report
properties, that is considered as Design Change which causes the Login
Popup for ADP and error for ADE.
I found at least 2 posts that described the same problem, but
unfortunutely no solutions.
http://groups.google.com.au/[email protected]&rnum=1
and
http://groups.google.com.au/groups?...e=UTF-8&selm=OLJZjnA%23AHA.2120%40tkmsftngp07

The problem occured even on the simplest project with one report, one
form and one button that outputs the report to html.
Is it a MS Access bug, or there is some workaround for the problem?

Michael Freidgeim
 
Top