we are taking data from an internal database and putting it on the web. we don't want the web to have access to our database in any way
we currently have a routine that does this-
DoCmd.OutputTo acOutputQuery, "Current Jobs", acFormatHTML, "c:\OpenJob.html", False...