[TriLUG] teenie weenie database/web project

[Turnpike Man]

Agreed.  The major app here is a few Access databases tied up together... it's
just not pretty.  A development project will soon be underway here to move it
all to (yes) MSSQL, but the frontend will be web based.  The webserver will be
RHL using apache, php, xml, as best I can tell looking at it from a still
brainstorming phase.  I honestly have no complaints with MSSQL (although I
could bash it) and I use mySQL at home which is great.  This company already
owns MSSQL, so I can't exactly let it go to waste, as much as I might want to
consider it already there. ;)

laters,
David


--- Joseph Tate wrote:
> 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>
> >  
> >

__________________________________
Do you Yahoo!?
SBC Yahoo! DSL - Now only $29.95 per month!
http://sbc.yahoo.com