Unanswered: Stock management database with web front end
I am new to this forum so hello!
I would like to ask some advise, I have started working for a small company that requires a stock control management system which can be update via the web as the users are normal operating remotely. I haven’t built a database since university.
Quick run down on company. We operate a specialist polymer coating company with large contracts with a major aviation company.
There are 3 separate sites for stock,
1. Main warehouse
2. Buffer storage facility (warehouse is very far from airport we operate)
3. Airport storage facility (kit needs to be checked in 24hrs before we can access it)
We need to be able to keep track of the products and equipment to apply it (Buffers etc). Make sure enough stock is available for each job, and know when to order new products equipment etc or move it up the chain.
Before I want to start I need to make sure I’m heading down the right path. I am thinking of doing it in Access 2007 and ASP front end.
Like I said we are a small company and there is not a huge amount of entities for this data base, nor quantities of product. If anyone can point me to templates or any other help would be great help
Access is itself not browser enabled. The beta of Access2010 begins to introduce this but not to the extent that you are going to need now. So these are your options:
1. Use a web site/architecture: Whether it be ASP (Microsoft's brand) or PHP (OpenSoure) or ColdFusion or whatever...in which case the db that supports it is somewhat secondary to the overall solution. Which is only to say you wouldn't need to force Access into it if your developer is more experienced with sqlserver or mysql....
2. Use the www . AccessTables.com service; suitable if each location can upload the tables on a periodic basis. Good thing is each db runs separately & locally which means it is fast. But if you need instantaneous real time common inventory updates then this isn't the solution because you only sync the dbs periodically...
3. Highspeed private network where Terminal Services is available. This is a big corporation solution. Routine in that world - but generally not available/affordable to small companies. Complex. The public alternative to this is something like the GoToMyPC.com service. User vpn into the central network and use it as if they are locally based. There will be issues. There is latency/delay in the user experience - - and PCs must be on in the main office.
In all these there is an elegance vs price trade off.
Thanks for the response.
This is a very small operation, the manager, me the project manager a secretary and about 15 laborers.
only one person will access at a time so maybe i dont even need a web front end remote log in is an option keeping the db on one machine. ideally i would like to have something i can access via blackberry what solutions would be available for this?
there is a 4th option I failed to mention; which is the use of a web/browser based database service. There are 2 out there worthy of mention:
QuickBase (is an Intuit service and expensive)
In these type services you are in their sandbox and so the layout, features, capabilities are defined by them - as opposed to Access where your flexibility is quite high. just fyi.
Nothing is inherently BlackBerry enabled. Browsing of course is browsing and doesn't matter if that is from a mobile device or not.
I stand by these 4 recommendations as your alternatives. Any one of them could be your right decision - they all offer trade offs. You should explore each and decide.
when separate locations need to run Access - - and they don't need instantaneous shared data updates - - the AccessTables.com service is a good solution because each db runs locally - so it is fast, plus users can do custom queries/reports on the fly and things like that.
In the right situation, it is the right solution. But then that's what it is all about.... Don't know of any packaged solutions because I don't really follow the industry in that dimension....