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>
_______________________________________________ TriLUG mailing list http://www.trilug.org/mailman/listinfo/trilug TriLUG Organizational FAQ: http://www.trilug.org/faq/TriLUG-faq.html
