Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    Join Date
    Apr 2017
    Posts
    1,673
    When you have your servers connected in wired network, you have on some server a shared resource accessible to every user of your DB, and you have a terminal server:
    1. You place your BE on shared resource;
    2a. When user is wired, he/she can have FE stored in his/her computer or on any resource in wired network accessible for him/her. User runs FE from his/her computer. At same tame, next options remains available too;
    2b. When user is wireless, FE is stored in user's Terminal Sever profile, or on any wired resource accessible from TS. User logs into TS, and runs FE from there;


    2c. When user works from remote location, he/she needs VPN connection to wired network, and access to TS. User connects to wired network, logs into TS, and runs FE from there.

    All data exchange between FE and BE is done over wired network. In case FE is run from TS, over wireless connection only images and keystrokes are moved. So risk of DB corruption is same as when working in wired network.

  2. #17
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by ArviLaanemets View Post
    When you have your servers connected in wired network, you have on some server a shared resource accessible to every user of your DB, and you have a terminal server:
    1. You place your BE on shared resource;
    2a. When user is wired, he/she can have FE stored in his/her computer or on any resource in wired network accessible for him/her. User runs FE from his/her computer. At same tame, next options remains available too;
    2b. When user is wireless, FE is stored in user's Terminal Sever profile, or on any wired resource accessible from TS. User logs into TS, and runs FE from there;
    2c. When user works from remote location, he/she needs VPN connection to wired network, and access to TS. User connects to wired network, logs into TS, and runs FE from there.

    All data exchange between FE and BE is done over wired network. In case FE is run from TS, over wireless connection only images and keystrokes are moved. So risk of DB corruption is same as when working in wired network.
    Even though I still didn't get the main reason behind access database corruption in wireless networks ( as far as I know, data is transferred using TCP/IP protocol which provides data integrity ), but yes I agree with you, the risk of DB corruption when FE is run from TS over wireless networkis the same as when working in wired network.

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Issues with database when working remotely
    By wolfm in forum Database Design
    Replies: 3
    Last Post: 11-01-2019, 01:24 AM
  2. How to Add/Edit records remotely
    By Athar Khan in forum Access
    Replies: 17
    Last Post: 10-02-2017, 04:03 PM
  3. Remotely sharing a complex access db
    By MS123 in forum Access
    Replies: 5
    Last Post: 11-28-2016, 10:32 AM
  4. Using Access Remotely - Do I need SharePoint?
    By kevins in forum SharePoint
    Replies: 1
    Last Post: 01-17-2012, 02:53 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