MySQL database

[Chippiewill]

It can do everything you ask for if you set it up properly.

Just setup tables for uniform, incident and occurances and then setup merge to word and you've got everything you wanted except webmail (And if you link it to a MySQL DB then you have that as well)

No need to overcomplicate things and sacrifice security.

[Luke]

It can do everything you ask for if you set it up properly.

Just setup tables for uniform, incident and occurances and then setup merge to word and you've got everything you wanted except webmail (And if you link it to a MySQL DB then you have that as well)

No need to overcomplicate things and sacrifice security.

I wouldn't know where to start with the Access though , whereas with the VB idea, i can literally make the UI, and just include the PHP files - easier for me and it's quite secure, seeing as it's only installed on one computer

The PHP files are user authenticated using the squadrons website login, and it also requires a .htaccess password to access it initially.
I've been working on it this morning, and i've nearly succeeded

[Recursion]

Why not just go with what you're comfortable with and use PHP/MySQL...?

I'm creating support desks, asset databases, intranet with news and all sorts for work and I'm just doing it in PHP/MySQL and shoving it on a virtualised LAMP server, it'll integrate nicely with our Active Directory too, making it dead easy to keep secure.

[Luke]

Why not just go with what you're comfortable with and use PHP/MySQL...?

I'm creating support desks, asset databases, intranet with news and all sorts for work and I'm just doing it in PHP/MySQL and shoving it on a virtualised LAMP server, it'll integrate nicely with our Active Directory too, making it dead easy to keep secure.

I basically am, I'm just creating an application to hold it in, and to access everything easily - like i've got a menu for printing forms off, so we don't have to log into the MoD secure area and download it every time, just print it straight from the application