12-11-07, 01:35 #1(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
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 pointhope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON
12-11-07, 04:44 #2Jaded Developer
Provided Answers: 59
- Join Date
- Nov 2004
- out on a limb
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).