By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,879 Members | 1,809 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,879 IT Pros & Developers. It's quick & easy.

MS Access generates too much html code

P: 2
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
Feb 7 '08 #1
Share this Question
Share on Google+
6 Replies


harshmaul
Expert 100+
P: 490
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.
Feb 7 '08 #2

P: 2
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.
Feb 8 '08 #3

harshmaul
Expert 100+
P: 490
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...
Feb 9 '08 #4

ronverdonk
Expert 2.5K+
P: 4,258
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
Feb 11 '08 #5

Death Slaught
100+
P: 1,137
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](")
(")(")
Feb 11 '08 #6

drhowarddrfine
Expert 5K+
P: 7,435
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.
Feb 11 '08 #7

This discussion thread is closed

Replies have been disabled for this discussion.