Database project help

[Codeweaver921]

I am in need of assistance in producing a database. The database is simply a "log" or "record" which i need to work in the following ways:

> a user enters a password to log onto there own little area of which they can fill out forms asking thing such as: how many hours done, what they have done etc.

> an administrator can then log on and look at everyones accounts and print off reports etc.

I have had ago at this and made some progress but i am very stuck so any help is greatly appreciated.

Thankyou!

 

[rsmonkey]

well fire away wat are you stuck on?

 

[Codeweaver921]

Everything really!

I think i have made a working password script but it is very basic - simply reads a table of passwords, if the information you entered is in the table it lets you through to the next page. So an update to this will be greatly appreciated.

Secondly i have no idea how to make it so that when a user logs on with their password it takes them to their own little area that only them (and admins) can view and change. I am trying to make it so your enter information such as: name, what activities you are doing, how long you have been doing them for etc. I am looking at there being around 100+ users.

Thirdly i need to set it up so admins can view the data entered by users and change and update it.

Hope this helps and if you need any more information just ask. Thankyou!!

 

[KeithG]

If you going to have a 100 plus users I would consider using a different RDBMS such as Oracle mySQL or SQL Server. Access is a desktop database and what you ideally want is a Client Server db. But if you stick with access I would suggest using workgroup security. Any password script that you or an other access developer can write can be easily bypassed by the correct person.

 

[Codeweaver921]

I dont want it to run on the internet i want it to be able to just be open on a local server. Does mysql allow this?

thnx

 

[KeithG]

Yes I believe so.

 

[Codeweaver921]

I have a mac as my main computer, would i be still be able to create the database on mac but whilst allowing a windows to still be able to use it or will i have to convert it into windows format.

And since i have never used mysql before do you have any tutorials or help pages etc.

thanks

 

[rsmonkey]

first of all you need to ask how many user are going to simutanously use the db at any given time? As keith said if its alot of people then access is not the program for you.

Oh and before you get into creating login & password scripts you need to create your db and getting it fully functional. Implementation of user login & passwords scripts should be one of the final stages. Produce an ERD (Entity Relationship Diagram) or something along those lines and logically show us how you are going to create this DB. Once you done that, thats most of the hardwork done!