[TriLUG] teenie weenie database/web project
Joseph Tate
jtate at dragonstrider.com
Wed Jul 9 10:21:29 EDT 2003
I did a quick search on "inventory tracker" at source forge and came up
with the following:
http://myparts.sourceforge.net/
It's an early beta, but may it be easier to modify this project to meet
your needs. If not, I would suggest that using PHP/mySQL is as easy to
make distributed database apps as using Access (and fewer headaches too
with Access's known problems sharing data: deadlocks and crashes, etc.
Just ask turnpike420). Then again, you may come up with a better search
term and might have better results. I don't have time to do it myself,
but I'll be happy to help if you get stuck.
Joseph
Jim Ray wrote:
>as an alternative to chucking a winders machine with an access database
>in a client site and trying to get some kinda asp/html thang gwine on, i
>wanted to find out if anybody had time to whip something out in the next
>few days with an open source solution.
>
>if so, please contact me off line.
>
>here are the details:
>manufacturing plant has in house store. employees get parts and write
>down on clipboard date, part#, description, quantity and their employee
>ID.
>
>i'd like to have a single server solution that serves up a web page with
>those fields, chucks 'em into sql, and pukes out some kinda *.csv file
>onto a samba share on a weekly basis.
>
>here's the kicker:
>if it works well, client would like to add inventory, vendors, min/max
>reports, ya da ya da ya da.
>
>so, if somebody gotta idea on the initial quick and dirty start
>replacing the clipboard thang and wants to pick up a little chump change
>on the side, contact me now.
>
>otherwise, i go on ahead with
>
><flame-shield>
>winders and access.
></flame-shield>
>
>
More information about the TriLUG
mailing list