getting access data to the web.

[LTM]

i have an internal database that I can use to get data i want the world to see. The data does not need to be updated more than daily. so the data does not have to go to the web as soon as it is entered.

If i use data access pages it wants me to supply my Access2000 password. Do you need access2000 to view data access pages? if so that that would be bad. is there a work around? Is there a better way than this.

If i use reports the formatting is spartan- i think I can get around that but it is not the preferred solution.

larry

 

[mp9]

You can create a query and then export that in HTML format to your webserver.

http://www22.brinkster.com/accessory/

 

[LTM]

i am having trouble getting it to look "pretty" any suggestions. the biggest problem is that the columns are not coming out straight when i view the HTML in my browser

larry

 

[mp9]

In VBA, use OutputTo, i.e.

DoCmd.OutputTo acQuery, "qryYourQueryNameHere", "HTML(*.html)", "c:\temp\destination.html", False, "c:\temp\html_template.html"

This lets you specify a template and stick the contents of your query into a new (destination) web page based on that template. And your columns will line up!

http://www22.brinkster.com/accessory/

 

[LTM]

thanks mp9

this will work, though for future reference the "HTML(*.html)", is replaced with acFormatHTML in my access 2002

larry