Log in

View Full Version : ACCESS Programmer needs an advice !!!


ljubo
11-16-2006, 01:47 AM
I have developed a serious ACCESS Aplication for restaurant managament.(accounting + touch screen POS). Now I need to develop a remote ordering restaurant system using some kind of PDA devices ( IPAQ for exemple). My idea was to make Wireless LAN between PDA devices and my server and then to write a front-end app running on a PDA device which will be linked to my ACCESS database. Thanks to my poor knowledge of PDAs, In the beginning I thought I would be able to write some kind of ACCESS aplication on PDA but it seems not to be possible.So I need an URGENT ADVICE from someone experienced in this matter:
WHAT IS THE BEST WAY to develop a simple aplication on a PDA device which whill be linked to
my ACCESS databese on the desktop server ( assuming wireless network ). If this is not possible
with ACCESS I need to know if it is possible with SQL*Server (That would solve my problem too ).
Thanks in advance !

Sven Johannsen
11-17-2006, 05:37 AM
I believe there are options for you using SQL Mobile and an Access connector of some sort. You might check on the SQL Mobile site at MS.

On the other hand, have you considered trying to use the relatively easy ability of Access to create an ASP web page, scale that page down to PPC appropriate size and use PIE. You would of course need some sort of web server to support this, but if you are considering SQL Server this probably wouldn't frighten you.