Hi guys

I have a web page using asp for a funiture catalogue.
Everything is fine, but just out of interest, if i were to have articles on my site and want to read it from a data base how do i do it? Surely there a limit to how much data you can put in ms access db cell. Is there other database software i can use with this?

Please reward my curiosity <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>
(not by giving me a vanilla coke<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

thanks
s69

HI,

To build a dynamic site that interacts with a db follow the tutorials in Dreamweaver and you will find yourself getting started pretty quickly.

As for size, access will hold a suprising amount of data, and dependant on the field type you would not normally run out of space.

Textfield: 255 characters
Memo: More than you need
Access: Dont let it get over 1gb or things get messy (it has closed down on me before)

If you want something a bit more industrial you have two Microsoft options:

Mysql: Free but not that easy to config (certainly no user interface like access)

MS SQL Server: Costly but the mutts danglies with great tools for configuration and the real deal for industrial solutions.

If your site is small to medium sized, and you are just starting out I would recommend sticking with access. when you skill level increases, start playing with MYsql or SQL Server.



Regards
Vince

DMX Talkzone Manager

Visit my home: www.chez-vince.com

VBScript | ASP | HTML | SQL | Oracle | Hosting