Writing Static Webpages from Access

Best methods

[ukgimp]

I have the relevant bits for an application that could create pages on a server from a static database. I can create the folder, create the .asp page, and write to it. I was however wondering what whether there is a good way to write to the page itself. Escaping all the characters from the template will be difficult. Nice and easy in php with the "\" but not so in VB.

Any tips on how to get around this or even an alternative approach.

Cheers

[IanTurner]

Are you looking to create static pages on the fly, or as a batch job?

[ukgimp]

Hello Ian

Batch. They only change once a month.

Cheers

[IanTurner]

Use the FileScriptingObject - you can either write a VB Program to generate the pages or have an ASP page generate them, it depends on the access you have to the server. If you have an ASP page generate them you need to have folders that have IUSR write/delete allowed on them.

You can of course remove this privilege once the pages are written.