which technology to use????

I am developing a windowsXP application which requires a username and a password for the users to login. There is not going to be more than a thousand users. However will probably stored extra user info (full name...) in the DB as well. It will be called either from a .exe or a ASP.

The password database will be locally stored.

I have never programmed a database before.
I want my database to be very secure.

Which technology should I use. ( Oracle, SQL, MySQL...?)

Does VisualStudio.NET offer database tools.

I suggest using ms access to store 1000 records than MySql or oracle.

krishnakumar: I assume you meant that as a joke. If you were serious then you are an idiot.

How are you storing the password locally. Is this to be stored on each machine? If so you cant use a database that is secure to store it since they all need to be installed. All data should be stored on a secure central server. One thing you need to make sure is that your program is secure, its no good having a secure database if your program allows them complete access

Dear Andreas Koepke:

I dont find any thing stupid in using access data base, locally or in a central server.
Infact the idea of using Oracle or MySql to store just a 1000 records is stupid.
you can always make the data secure using encryption or any other techniques.

i agree, storing 1000 records in oracle or ms sql is stupid. but you should pick mysql over ms access if those are your options.

MS Access is a bad choice for any solution.

small-> medium sites MySQL.
Medium -> large PostgreSQL
large -> huge Oracle

Access has it's own spot in the market, is an excellent PERSONAL database (and beside that, it has a much more complete SQL syntax than MySQL).

I agree, Access sounds fine for this setup, provided you will not have significant multi-user data updates. You could also look at FileMaker Pro, too.

I agree with a.koepke. I have used access, Oracle, Sybase and postGres and I would never use access again unless I was forced to.

Web servers by their nature are multi-user and in my experience that's where access falls flat (as well as increase in data load).

Don't get upset guys, I'm yust saying (again)
This is for all those who just say is crap.

For the specific issue I agree with hedge.

I would recommend SAP DB anytime - unless you are making a site the size of Amazon.com - then maybe I would consider Oracle.

SAP DB is free, it's a great performer, runs on anything with a pulse, it's supported and developed by SAP's own R&D - and best of all: it's a 'living' product - SAP uses it themselves in the applications they sell (mySAP).

The support is great: If you have any problems you just email them, and they respond promptly.
All emails are gathered in a groupmail sent out two or three times a day.

By the way:
The initial post asked about Visual .NOT having some kind of db in it.
I have used Visual FoxPro with great pleasure a long time ago. I think that it has become a part of the studio-package now.