| | |
|
|
|
Re: Handhelds/PDA's |
|---|
| message from Sam Goddard on 5 May 2004 |
What is the best way of using a handheld device within a warehousing
environment in order that it can make use of access databases? Is it best to
create a web-based project that the devices can interact with or is there
another way that I am as yet unaware of?
Thanks
Sam
"Pieter Wijnen" <mysurnameonly@online.no> wrote in message
news:hJ_lc.153428$jf4.8202433@news000.worldonline.dk...
|
| Sam Goddard replied to Brendan Reynolds on 5 May 2004 |
OK
so, assuming that I have wireless networking in my warehouse & I have an
access-based project that can be manipulated with ASP or something similar,
a handeld device can use this.
Basically it's a stock system that will enable users to take orders from
customers & then procees them in the warehouse.
Does this make sense?
" <brenreyn at indigo dot ie> wrote in message
news:ePsDFwpMEHA.684@TK2MSFTNGP09.phx.gbl...
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnppc2k2/html/dataaccessstrategy.asp
|
| Brendan Reynolds replied to Sam Goddard on 5 May 2004 |
I never did much work with 'classic' ASP, but I've written a couple of
ASP.NET mobile web apps using Jet databases and yes, it works well under
appropriate conditions. Strictly speaking, and at the risk of sounding
pedantic, there is no "Access-based project" involved in this, though.
There's an ASP.NET application and a JET database, the only use of Access is
during development, to design the database and create queries. While the
application is running, Access is not involved at all.
I'm not sure about the users taking orders from customers using such an app
though - remember the web-based app will only work while the device can
connect to the web server. If you mean users will visit customers, at the
customers' premises, to take the orders, then you're talking about an
intermittently connected scenario where data will need to be cached locally
on the device and merged with the central database later. (Unless you use
something like GRPS for remote access, which, in this part of the world at
least, is ridiculously expensive.) That's certainly doable, but again, not
with Access. You'll likely get more, and more detailed, answers in other
forums that deal with the technologies involved in that scenario.
There is a *lot* of information about this stuff in the MSDN library. Here's
another URL well worth a visit ...
http://msdn.microsoft.com/library/en-us/dnanchor/html/anch_mobilewebdev.asp
... and I can also recommend the books "Building .NET Applications for
Mobile Devices", Andy Wigley and Peter Roxburgh, and "Microsoft .NET Compact
Framework", Andy Wigley and Stephen Wheelwright, both published by Microsoft
Press.
|
|
Archived message: Re: Handhelds/PDA's (MS Access Forms)
