Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    New Zealand
    Posts
    1,423
    Provided Answers: 8

    Unanswered: MSaccess (well the data) on a PDA

    Can someone point down the right Track

    I want to take a PDA on the shop floor and do a stock

    I have the tables built it currently work in a lappe that to big

    I know I have to create a vb interface just need the starting point
    hope this help

    See clear as mud


    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008
    MYLE
    YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    depends on how you plan on doing your stock

    one possibility is to use a wireless connection to the PDA and use wepages, you may need to put in more than one wireless access point if the warehouse is big enough or awkward enough in terms of gettign a uniform signal strength. Also the security implications could be a little worrying.

    you could use a barcode scanner in the PDA in addition to the touch screen / key pad.

    I know you can get an embedded variant of SQL server.. but I don't think there is embedded Access

    Unless you need realtime information the other alternative I can think of is a flat file.. or arguably a series of flat files in blocks of say product number... most moder PDA's can rip through flat files very quickly. the problem would be if you wanted to search for a product by name or description.. that may take a bit longer.. but then again the delay may be irrelevant if you identify the product in the warehouse, search for the product on the PDA, then do the count.. the PDA will undoubtedly have found the appropriate record(s) long before you finish your count. I don't think you actually need the full relational db to work.. nor do I suspect that you will need the full product tabel.. if you are doing stock control you need the detail of the product (description, manufacturer, possibly their stock no, your stock no, and current projected stock. you don't need any proce information or other non critical (to a stock take perspective).

Posting Permissions

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