Results 1 to 4 of 4
  1. #1
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2013
    Posts
    93

    Issues with database when working remotely


    Hello: Looking for some advise or best practice for the below issue:
    Sometimes one of our databases crashes or gets damaged beyond repair when users use the database remotely, via VPN. Our database in question is stored on a server.
    Are there any safeguards we should be taking to prevent this type of thing? Or, if this is common, avoid using it remotely all together?

    Thank you!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I have read that this is not reliable and should be avoided.
    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
    wolfm is offline Advanced Beginner
    Windows 7 32bit Access 2013
    Join Date
    Dec 2013
    Posts
    93
    Thanks June7!

  4. #4
    Join Date
    Apr 2017
    Posts
    1,673
    You must have a Terminal Server in LAN where BE of database is stored. The user logs via VPN to Terminal Server;
    You must have Access installed to server where TS is installed;
    The user must have a profile on TS, and his/her own copy of database FE in his/her profile, or in accessible folder in LAN;
    The user opens his/her copy of database FE from his/her TS profile, and starts to work.

    The gist of it is, the user opens database from LAN, not from remote location.

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

Similar Threads

  1. How to Add/Edit records remotely
    By Athar Khan in forum Access
    Replies: 17
    Last Post: 10-02-2017, 04:03 PM
  2. Remotely sharing a complex access db
    By MS123 in forum Access
    Replies: 5
    Last Post: 11-28-2016, 10:32 AM
  3. Using Access Remotely - Do I need SharePoint?
    By kevins in forum SharePoint
    Replies: 1
    Last Post: 01-17-2012, 02:53 PM
  4. Making Access Application Authenticate Remotely
    By section.echo in forum Programming
    Replies: 1
    Last Post: 11-03-2011, 04:05 PM
  5. Accessing my inventory remotely
    By Steven in forum Access
    Replies: 2
    Last Post: 02-27-2010, 11:56 AM

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