What programming to use!

[USMCorps04]

Alright I have a database that needs to be user friendly and idiot proof to use after being built...basically the fields will include social security numbers, last name first name, from and to travel dates using yyyymmdd format recieved denied and dates paid...but beable to retrieve and edit the row when needed by looking up from ssn or name..(but what if there is more than one claim)? well what would be the best program to use...i was guessing access but wasn't sure...somone mentioned php does anyone know what programming language or program to use?

[k1ll3rdr4g0n]

Access is just a database file.
You could use almost any language for access.

PHP + MySQL should work for you what you need.
Check out this link: http://www.tizag.com/mysqlTutorial/

[USMCorps04]

so access cannot be or act like a program sorta like vb but strictly db?

oh this is not just possibly a server required program atm

[dclamp]

well it really depends on what you want. Do you want it to be a web application?

Here is a break down:
PHP + MySQL - Not the best because it is a web application, open for anyone
ASP.net - Safer then PHP, still a web app that is open for anyone
VB.net - Windows App, Only open to who ever uses that computer (depending on the setup)

[penagate]

First tell us how you need to access the data. There's no point us offering a gazillion suggestions without knowing what you need.

[Shaggy Hiker]

By the way, Access might be sufficient. There are plenty of full applications built in Access, because there is a pretty full featured VBA language, report generator, etc. built into the program. I don't particularly like that solution myself, as it is somewhat straightjacketed, but I've seen some good stuff done with it.

VBA is basically like VB6, so that would be the language. If you know VB6, then VBA will be pretty nearly the same, and vice versa. There will be significant differences between the two in how you deal with UI, but the languages are pretty much the same.

[GaryMazzone]

I'm sorry to tell you that you will never make the anything "Idiot Proof". As much as you will try some one will build a better Idiot out there and they will do something you never thought of. You do the best you can an plan for whatever you can think of. Have someone else look it over tyr it and do what ever they come up with as issues. But Idiot Proof -Never.

[EDF587]

I would go with Access to be honest.