Results 1 to 3 of 3
  1. #1
    JJ Jessee is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Nov 2017
    Posts
    1

    Updating a remote MSAccess database without an MSAccess frontend

    Hello, World.


    I haven't programmed seriously in Access for a decade ++,
    but I have a project I'm thinking about.

    I want to have my service techs log their Job hours, Time IN, Time Out, Employee Number, Job Number, Lat&Long Coordinates, etc...) using a tablet device from the job site. The tablet would not be running Access (unless that's the cheapest solution) The database would be back on the office server or Idrive. I'm not tied to remote updating, but really would like the Techs to log their own time records in REAL time rather than having a person key the records from a paper timecard (which we've done since the early 80s) and attach them with a reasonable degree of automation.

    Any suggestion on learning to code this or an existing soluton? I've RTFM over the years with decent results if you've know a good one to start with.
    I'm in the Metro DC frequently and class training might be an option.

    Thanks
    JJJ

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    49,881
    Other platforms can connect to Access tables but makes it way more complicated to build interface forms.

    Don't need full version of Access on tablets. Access Runtime should run on tablets with the full version of Windows, such as Microsoft Surface Pro. Runtime is free.

    The real trick may be the remote connection to server. How do you plan to do that? Cable or wireless? Using MS Remote Desktop Connection?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Ajax is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    8,702
    you can have your backend on something like AWS or Azure which will give them access to the (sql server) db - but you need to overcome the firewall issues - typically they are based on known IP addresses.

    Other options to the access runtime environment is you can design an excel form with vba code to update the backend - but that requires Excel which means an office license.

    No reason the techs can't log their time locally and update the backend when they have a connection.

    Note that tablets are typically wireless. Wireless connections and access work but expect glitches which can result in corruption, so much better to use sql server/express which manages connection outages much better.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Learn MSAccess by playing MSAccess Jeopardy
    By pkstormy in forum Sample Databases
    Replies: 4
    Last Post: 11-17-2016, 07:27 AM
  2. Downgrade MSAccess
    By Luciano in forum Access
    Replies: 11
    Last Post: 08-25-2016, 12:53 AM
  3. Replies: 8
    Last Post: 10-10-2013, 12:27 PM
  4. plz explain how to use iif in msaccess
    By pabbiraj in forum Access
    Replies: 2
    Last Post: 05-22-2012, 01:39 PM
  5. MSAccess and ADP (web pages)
    By maxcannon in forum Access
    Replies: 0
    Last Post: 01-20-2012, 02:45 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums - Senior Forums