Click to See Complete Forum and Search --> : Database


pat_masters
December 7th, 1999, 10:17 AM
Well, I am back, and I just wanted to thank all of those who did not flame me for being a newbie. I just wanted to say that I have a newfound respect and now a greater admiration for you all and your utmost professionalism.

Of course, I also have a question. I have been working on this program for my job. It basically is a database program. It allows our asociates to access a database with a wealth of information on our products. For instance, they would click on the computer tab, and since our employees are not technically inclinded, nor are our customers, it would be as simple as clicking on the manufacturer and then clicking on the model of the computer which would then contact te database, it return the information to the corresponding boxes on the screen (i.e. type of processor, warranty, size hard drive etc..)

Now the questions I have are as follows: I have GUI done already. Now I have come to the part where I need to start entering information for the database. The first question I have is what would be a good database to use? Keep in mind that over a 1000 people will be using this database, although not all simultaneously. So, speed will be a minor issue. Also, I am also looking to use a database that is easily maintained and upgraded since I will have the sole responsibility of adding updated information.
I have no programming experience (absolutely none, other than the GUI I just accomplished.) Should I use Access as the database? I was thinking of using Excel somehow but have no clue how I would do it.

I have a copy of the GUI I have created if you would like to take a look at it to give me some ideas. I really need help on this one.

I also want to say thanks to Michael Bechard. You are truly amazing and patient. Thanks for all your input.

Patrick Masters

Allen Noakes
December 7th, 1999, 10:29 AM
Patrick,

In my professional opinion I would stick with Access. You could try SQL Server 7.0 if you wanted to but it is more complicated.

Allen Noakes
VB Programmer/Analyst
Dames & Moore Group