Yes, the computer with your database will need to remain on for Remote Access to work. It is also important that your server computer have an active internet connection. If either of these requirements are not met remote access will not function.