[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 541
  • Last Modified:

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?
0
paulmcneil
Asked:
paulmcneil
  • 3
4 Solutions
 
Aaron TomoskyTechnology ConsultantCommented:
If you go with a web page it will work on most devices
0
 
Jeffrey CoachmanCommented:
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
 
Aaron TomoskyTechnology ConsultantCommented:
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
 
paulmcneilAuthor Commented:
Thanks for the replies. aarontomosky, when you say move the back end to sql, do you mean sql server?
0
 
Aaron TomoskyTechnology ConsultantCommented:
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now