please help with putting an html file in an access databse?

Question

first, i want to know if this is even possible? i want to put an html file in a Ms access database and then be able to view it in internet explorer. i all so want to be able to edit it. the reason i want to do this i cuz i'm trying to set up a site where people can set up an acount and have their own personal page. that page would be stored in the database and the users would be able to edit it. how do i put a web page in a database and then display on the internet? i all ready have the database on a free web serve. if you could help me i would greatly apreciate it. thanks!

P.S. i'm just expiermenting, so i dont want to pay money in order to make this work.

Answer 1

To store a HTML in Access database, just make a field of "Memo" type (unlimited chars). OLE fields make not much sense on the Web.
But, in real life, it will not work, because most HTML pages link additional files (pictures, client side code, e.g. applets). You would need to store the files in the database too...

You should limit the database to hold account info and file location of the personal page (relative to root of your web site), then use this info to navigate to the page. Keep the HTML pages as they are, in files on folders.

Answer 2

Saving an HTML into the database will not be a problem - you can use OLE object to embed HTML into an access table. I have implemented scenarios in the past that required saving Word Documents/Excel Documents and even Bitmap Images into the database... but having them accessible through a website is something more complicated.

From top of my head (and there may be a better approach)- I would need a webserver that will host jsps and servlets. The jsps will provide interface for the users to log on and submit request to fetch their webpage... the request will be passed to the servlet to fetch the OLE object then serve it as an HTML stream. Hope this makes sense.

.