Internal Database Server

[saveus222]

Hi,

I am thinking of starting a new project in office. The project's idea is to create an internal database of all kinds of things, as a backed, and create a frontend to interface with that. Now I am pretty new to coding, therefore, i would like to know the following things.

1) what technologies have the most simplicity and effectivenes. (php,java,etc etc)

2) what backend software to use ? like for a database. is MYSQL necessary or Microsoft Access is good enough ?


3) how do i go about designing this ?:):D

[Serpentarius]

i did my server by myself ... so i didnt knew any other stuffs ...

front end ---- VB.NET
back end ---- MS SQL Server (eval edition, free)

i cant figure out how middleware works ... so didnt code it ..

to avoid potential reverse engineering purposes .... i used the thin client, thick server concept ... so i place a lot of coding in t-sql scriptings .... then utilize the thin client to run the t-sql
i'm bit paranoid bout other user hacking into my server .... lol

[W1zzard]

windows + iis + .net + ms sql server is the microsoft way of doing things

apache + php + mysql or some ruby + mysql combinations are from the unix world (run on windows too)

what you implement depends on your preferences, budget, prior knowledge etc.

[saveus222]

oh....now im already confused.. :D im possibly gonna be running windows so the most ideal way to do it is windows + iis + etcetc. i guess ill have to read up on VB.net :D

[W1zzard]

have you been programming before?