Database Driven Website

[sinistapenguin]

Hi All

I am looking to build a website for a client which allows him to display cars he has for sale.

Basically I want to build an ASP frontend and a single table database 'Cars'.

In the past I have built applications using an MS Access database backend as I could then use access to make any necessary database changes. These applications were all offline though and now I want to put one on the internet.

I'm not sure MSAccess is the best thing to be using when putting the app online.

Does anyone have any recommendations of what I should use and how to go about it?

Thanks

Sinista

 

[vacunita]

I would serioulsy recommend MYSQL as your Database. It Can work well with ASP, but would recommend using PHP.

Any way, for online db access MYSQL is the best, and its free. You can download it at

http://www.mysql.com.

Also you can download the MYSQL administrator App, to help you in constructing the DB and the tables, and creating users and assigning permissions and rights to the users on a particular db or table.





----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[sinistapenguin]

Thanks for that.

Which bit do I need to download as there seem to be hundreds of possibilities.

Do I need to purchase the Commercial license if I am selling the web app I design?

Thanks

Sinista

 

[vacunita]

You would wan't to download this version:

http://dev.mysql.com/downloads/mysql/4.1.html

for whatever platform your planning on running it.

If you plan on running it on a Windows machine, then you would go for the Windows Binaries. Either the Windows essentials or the Standard Windows(x86). the Essentials is a smaller download, but has less features than the complete download.

MYSQL has an Open Source license. That means its free under these terms and conditions. You might want to read the license and check to see if your covered.

http://www.mysql.com/company/legal/licensing/opensource-license.html

----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.