Remote Data Entry From Portable Device to MS Access Database

My client is a bus company for whom I developed an MS Access app that resides on the company network and is multi-user. Now the client would like to equip the bus drivers with a protable device for entering data into the MS Access database back at the offiice from the field. The office pcs run Office 2007 on windows XP. Any ideas where to start with such a cionfiguration? Which portable devices?
paulmcneilAsked:
Who is Participating?
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
The first step would probably be to move the backend to sql. Then a webpage is just another front end that talks to sql, just like access would be. You could even sub this out as it doesn't sound like it's your thing.
0
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
If you go with a web page it will work on most devices
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
I agree with aarontomosky.
However, this will require you to re-design most of the database...

With an mdb file this is fairly difficult to do.
Among other reasons, ..MS Access will not run reliable, wirelessly...
0
 
paulmcneilAuthor Commented:
Thanks for the replies. aarontomosky, when you say move the back end to sql, do you mean sql server?
0
 
Aaron TomoskyConnect With a Mentor SD-WAN SimplifiedCommented:
yes.
mssql server 2008r2 is the current version. The express edition is free and the main limitations I know of are a 10gb database and 1gb of ram. Probably fine for something that was living in access
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.