Please help !!!
I am designing a database system and I am a bit stuck and do not know my next step forward. I am using SQL Server 2000 to develop a database system from scratch for a medium sized company which does not have an IT dept therefore I have little or no help.
this is what I want to do although I am not very sure how to do it. I want to develop the front end for SQL SERVER 2000 using HTML using the middleware ODBC!!! though not very sure how to go about it.
The other general Qns?? since this is my first time using MS SQL Server 2000 what are the stages that I need to do in order to complete this project, like I said before this is what I have done
· Created the database
· Created the tables
· Assigned the primary keys
· Assigned the relations (relationship diagram)
. Done the stored procedures
. Roles and users (Granting them different access)
My ultimate goal is to develop a web based database so that workers can log online and be able to view and update the details, as their access rights will allow them.