Remote Data Entry From Portable Device to MS Access Database

Posted on 2011-04-19
Last Modified: 2012-05-11
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?
Question by:paulmcneil
    LVL 38

    Assisted Solution

    by:Aaron Tomosky
    If you go with a web page it will work on most devices
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman
    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...
    LVL 38

    Accepted Solution

    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.

    Author Comment

    Thanks for the replies. aarontomosky, when you say move the back end to sql, do you mean sql server?
    LVL 38

    Assisted Solution

    by:Aaron Tomosky
    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

    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    MS Access question 11 39
    How to parametrize bing map on webbrowser control 6 34
    VBA exception error 5 22
    message box formulas 3 17
    Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now