Database and Programming Help

[apalrd]

I have not worked much with Access, but I am quite sure it has the ability to generate forms. That said, I would not recommend it after all the trouble I have had with it in the past.

I have had great luck with Php/MySQL and PhpMyAdmin all running under XAMPP on my Win machine. A custom PHP frontend for inserting, and data can be sorted with SQL queries in PhpMyAdmin.

[Boydean]

Originally Posted by apalrd

I have had great luck with Php/MySQL and PhpMyAdmin all running under XAMPP on my Win machine. A custom PHP frontend for inserting, and data can be sorted with SQL queries in PhpMyAdmin.

I agree with this. You can really use something like CakePHP(cakephp.org) to get you started. Its easy to get started, and once you get the hang of it interacting with a database is super easy. Plus once you have the server going anyone can join without installing software, and you can make changes on the fly without interrupting any use.

With that all being said, I don't know how to really help you out. Never messed around with access/vb stuff that much.

[dqmot17]

Originally Posted by apalrd

I have not worked much with Access, but I am quite sure it has the ability to generate forms. That said, I would not recommend it after all the trouble I have had with it in the past.

I have had great luck with Php/MySQL and PhpMyAdmin all running under XAMPP on my Win machine. A custom PHP frontend for inserting, and data can be sorted with SQL queries in PhpMyAdmin.

And if you want to stick with the offline aproach (or maybe even online) SQLExpress is free (or if your school is registered with microsoft you can get a free SQL server through dreamspark)

SQL is much easier to read, learn, and implement. I would recommend that as it is an industry standard

[KC1AJT]

I have received a PM from a man named Scott that has volunteered to take what we have and change it into ASP.NET and SQL