Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Online Database

  • 07-07-2004 12:04am
    #1
    stereo_steve
    Registered Users, Registered Users 2 Posts: 1,227 ✭✭✭


    Hello Guys,

    I have a room full of computer hardware in the office and my boss asked me to make an inventory of everything we had. It would just be handy that people could view from their PC over the intranet what we have instead of rummaging through boxes and messing everything up.

    I don’t want to use an excel spread sheet because no one will use it.

    I originally planned to use MS Access and use visual basic to view it but that limits the inventory to the MS windows users.

    What I want to do is set one of the computers up as an internal server that will control a database of the bits and bobs we have lying around. Everyone will be able to use it.

    I have no database experience but I’m a quick learner and I have a decent amount of time to get it up and running. My question is can someone point me in the way of a freeware server that will run on XP and maybe a program that will help me create a Database?


    Thanks for any help that I get.

    Steve


Comments

  • #2
    Tom Dunne
    Registered Users, Registered Users 2 Posts: 23,212 ✭✭✭✭Tom Dunne


    Here is a list of what you can use:

    MySQL - a freeware industrial strength database Link . Can be a little hard to set up (none of your namby-pamby graphical user interfaces here), but it does the job quite well.

    PHP - a freeware programming language (think ASP) that will let you talk to the database and web server (so everybody can use it on the network). Link

    Apache - and of course a web server to allow remote updating/viewing of the database via a web browser. Link

    This is all a complete overkill for what you want, but hey, it's interesting to set it all up. The three components will sit happily on the one machine (I have them sitting on a Pentium 133Mhz with 128Mb RAM for the last three years).


  • #3
    stevenmu
    Moderators, Society & Culture Moderators Posts: 9,689 Mod ✭✭✭✭stevenmu


    I'm guessing you're already familiar with Access and VB, if so for the size of thing your doing it would be easier to go with ASP pages running in IIS. There's very good tutorials at 4GuysFromRolla that will show you pretty much everything you need. HTMLGoodies is definitely worth a visit to get an idea of the HTML behind it all. W3Schools has great references for ASP, VB, HTML and loads of other things.


Advertisement