creating login

[desperado]

Hi, I was hoping someone could help me out a lil bit here. I shall create a Program in Visual Studios 2005 (Im not sure if this is in the correct area **sorry mods if its not**).

I shall explain what i want the program to do, if some one could just let me know what is going to be the best way to carry out this operation, as some ppl have told me im going to have to use asp.net and others said using just studios with a database links should be fine. Im just puzzled quite a bit and im sure there are a few vb experts in here who could just tell me what direction i should be heading in.

well here is what i want my program to do:
1- To have a login Screen (with multiple users) I shall be an admin, but once logged in I should be able to create other users who are NOT admin. And delete users who are not in use.
2- I want to be able to add/remove items, and i want to be able to see what items have been borrowed by people, and what items have been returned.
3- When Users log on i want them to be able to ask for assistance with some problems so when they log on they would add something like "Monitor not working" and the Admin would log on and answer the problem.
4- When Users log on under a section, there are 5 computer suites, I want them to be able to look at some suites and let the Admin know what suite they want to book out and for how long, so a computer suite is blocked out under the users use for example maybe half a day and some suites shall be in use, finally
5- when users log on their screen should be different from the admins screen, users cant add/delete items and users, they can only see what items are available and who has borrowed items, they can only see what suites are available at what times, and can request assistance and log calls. Admin on the other hand can do all of that and add/edit/delete information.

Hope you have a general idea, Im kinda in split minds as i dont know what is the best way forward. Also im a bit rusty on my vb skills, I would like to see honest comments if you feel im biting off more than i can chew then its fine, and if you think i shall struggle on any of the sections and i should drop any of the sections please let me know.

Thank you for your time.

 

[desperado]

oh so do you mean 1 database and run the multiple tables off that database?

 

[cjard]

Yeh I know these are common problems, in the end I will have about 4 databases. Did you work on this by yourself?

Most of the work I undertake is on a solitary basis; I'm the only suitably qualified developer in the business for the majority of work that I do. We have a technology "team" that I operate within but by and large, every member has a separate role and defined boundaries that seldom intersect (and I usually get grumpy when they do, because the others work with less precision and attention to detail)

you have helped me with the resource management part...I don’t think I shall be using that part....im going to use this part...

I'm confused as to whether you are or are not using/doing the resource management part.

The thing is I connected access with vb by using wizard, which we all know how simple it is.

A similarly simple corolorary exists in VB.NET for all database technologies it supports.

I know lil sql, but before I knew nothing what so ever about sql and I still created a database in vb using access which was really easy.

For the most part, connecting to and defining a database within any RDBMS supported by the Visual Studio IDE, does not require knowledge of SQL. You may choose to incorporate it, however.

The thing is I want to go way out my way and achieve a lot,

I recommend you put most of your effort into providing a solution that meets the requirements, rather than sing/dance/do the washing up

but at the same time my tutor wants goals achieved. Would it be better for me to go down the standard route and have a working project or down the difficult path and have a half working project?

I think you have your answer; Pick whichever route allows you to completely satsfy the requirements thereby getting you a good grade, and also gives you invaluable knowledge for when time comes to get a job. There's no point getting a good grade if you didnt learn anything new and commercially applicable - you'll know a lot of nothing of substance to back up what you show on paper to the interviewer.
Theres similarly no point in failing to make a grade because you bit off more than you could chew - you'll know a little bit of everything and nothing on paper to show the interviewer.
Strike the balance using your own personal measures of how you define success.

Just one question how do you use oracle in vb?

The same way you use Access

I mean do you put the oracle coding within the vb coding,

Oracle coding involves PL/SQL - a modified form of Pascal. It has no place in the client side VBN environment.

and set up the tables somewere else?

As noted before, the first point of call in designing an rdbms enabled app is to get the back end data structure in place (set up the tables)
You dont necessarily do this using VB.. it depends on the project's requirements

My decision is to use oracle, I shall build up my knowledge on oracle, are there any resources on the net which talk about oracle in vb?

Oracle is an SQL enabled database, you should be considering more closely the notion of SQL in VB. That's given the term of ADO.NET. Oracle will remain separate from VB, as an entity.

Maybe some examples and see how I shall fit my database in to my vb program.

You dont put databases into programs; that train of thought is born out of long term exposure to the way Microsoft Access works. Databases are separate to the programs they support. THe program enjoys a 2 two data communication with the database, perhaps not even on the same machine. If the database isnt running, the program fails. If the program is not running the database sits idle.

one in access and the other in oracle, he would be more impressed with what I have to show using oracle.

Neither program is "in" the database - except in the case of Access playing host container to a VBA driven application. Demonstrating a knowledge of oracle and SQL is an academically greater goal than demonstrating a knowledge of Access and SQL, but it could be argued that demonstrating an appreciation for SQL's role in interacting with any database is a greater overall academic goal

Out in the real world, the interviewer doesnt care as much - he just wants to know if you can write complex SQLs to query whatever RDBMS they have running in the enterprise. Enterprises dont use Access very often.

 

[desperado]

thanx for your support, im looking at sql and hwo tis used in vb. I will be working on my prokect well starting it and if i require help in the future i shall not hesitate in to adding another post.

thanx again

 

[cjard]

Recommended reading:

http://msdn2.microsoft.com/en-us/library/fxsa23t6.aspx