MS Access generates too much html code

[robinr]

I am a user, not a programmer.

I use Access 2003 and wish to create html files from queries and reports.

This I can do, and the converted data will appear in a template.

However, high volumes of html code is generated, even in the template where I have styles, making the resultant file far too large for web viewing/downloading.

Can anybody help me reduce the generated html code. It needs automating when the html files are created in Access.

Many thanks

Robin

[harshmaul]

Hi,
for startes you should use something like dreamweaver to create html pages. use access to create tables and such for DB driven tables, but as this is the html forums, you should definately try dreamweaver to create your pages.

[robinr]

Hi,
for startes you should use something like dreamweaver to create html pages. use access to create tables and such for DB driven tables, but as this is the html forums, you should definately try dreamweaver to create your pages.

Many thanks prompt response. Guess I may have selected wrong forum. Yes I could use dreamweaver or frontpage for one off creations and I do. I want to create 20 html pages from Access queries/reports each with different selection criteria, monthly, and web publish. Hopefully I can somehow automate it. Database stuff on web is out of my league.

Interesting dreamweaver (I have old version), did not create the copied table - only the text so I lost the nice cols but did not create code. frontpage did display the table but also lots of code.

So creating in another software programme means largely a manual operation.

[harshmaul]

Hi,
Ask your question in the ASP forums, cos the best solution is you read the mdb file yourself (manually) and write some ASP to print out what you want to print out.

Personally I'm html, and php. but the asp guys in here are wikid, so repost over there...

[ronverdonk]

Hi,
Ask your question in the ASP forums, cos the best solution is you read the mdb file yourself (manually) and write some ASP to print out what you want to print out.

Personally I'm html, and php. but the asp guys in here are wikid, so repost over there...

Or you could read the Access tables in PHP (using DB abstraction) and make up your HTML pages from that.

Ronald

[Death Slaught]

I recommend buring dreamweaver and learning HTML yourself (trust me this will save you a lot of headaches). If I remember correctly when you code in dreamweaver it's output is designed for IE in quirks mode.

Thanks,
{\_/}
(' . ')
(")[DEATH](")
(")(")

[drhowarddrfine]

The new version of Dreamweaver is much better but still leans slightly toward IE, which is just a big bug. Most who have Dreamweaver only use it in 'code view' and never 'design view' for that reason. The other tools are good for organization, uploading, etc.

This thread has veered off and doesn't relate to html or css and I recommend continuing it in a more appropriate forum. So I'm closing it.