Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2009
    Posts
    3

    Unanswered: Stock management database with web front end

    Hi,
    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

    Thanks

  2. #2
    Join Date
    Oct 2009
    Posts
    340
    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.

  3. #3
    Join Date
    Dec 2009
    Posts
    3
    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?

    thanks

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    I would very, VERY strongly recommend you go with MSSQL or something comparable for this.

    ERP/MRP solutions based on Access almost invariably become a source of massive pain should the entity become more successful.


    To be honest, I would retain a professional DBA and/or developer to help you spec out your system. Questionable decisions at this point will cause all manner of shenanigans in the future.

    Have you considered off-the-shelf solutions?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Oct 2009
    Posts
    340
    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)
    DabbleDB.com

    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.

  6. #6
    Join Date
    Dec 2009
    Posts
    3
    Thanks for the responses, i will do allot more investigation before i decide on technology, it does seem access not the right solution.

    what off the shelf solutions are available?

  7. #7
    Join Date
    Oct 2009
    Posts
    340
    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....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •