%3CLINGO-SUB%20id%3D%22lingo-sub-1266135%22%20slang%3D%22en-US%22%3EGetting%20Microsoft%20Access%20to%20Work%20Remotely%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1266135%22%20slang%3D%22en-US%22%3E%3CP%3E%3CEM%3E%3CSTRONG%3EToday's%20post%20was%20written%20by%20Juan%20Soto%2C%20a%20Microsoft%20Access%20Developer%20and%20MVP.%3C%2FSTRONG%3E%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEver%20wanted%20to%20use%20your%20Access%20database%20remotely%3F%20Great%20news%2C%20Microsoft%20Access%20can%20be%20used%20remotely%20under%20certain%20conditions%2C%20and%20here%20are%20the%20best%20ways%20to%20do%20so%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3E%3CSTRONG%3ERemote%20Desktop%3C%2FSTRONG%3E%3A%20The%26nbsp%3Beasiest%20and%20fastest%20way%20to%20remotely%20consume%20your%20database%20is%20through%20a%20remote%20desktop%20software%3B%20from%20Microsoft%E2%80%99s%20Remote%20desktop%20to%20other%20commercial%20software%20that%20will%20allow%20you%20to%20take%20over%20your%20work%20PC%20remotely%20and%20continue%20using%20the%20database%20as%20if%20you%20were%20in%20the%20office%20(See%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.microsoft.com%252Fen-us%252Fp%252Fmicrosoft-remote-desktop%252F9wzdncrfj3ps%253Factivetab%253Dpivot%253Aoverviewtab%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C2d314ffc92714382254308d7d33583e4%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637210099127845804%26amp%3Bsdata%3D9WsPpHBvmHGQ0CDQBqURoP7erB3DNLajWmLkhLaqMbc%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EGet%20Microsoft%20Remote%20Desktop%3C%2FA%3E%20and%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.microsoft.com%252Fen-us%252Fhelp%252F4028379%252Fwindows-10-how-to-use-remote-desktop%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C2d314ffc92714382254308d7d33583e4%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637210099127845804%26amp%3Bsdata%3DvI0Bb5lytN7jabQGoyzZYaEmvaNG5v5LWMhBDA%252B1yhU%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHow%20to%20Use%20Remote%20Desktop%3C%2FA%3E)%3C%2FLI%3E%0A%3CLI%3EIf%20you%20haven%E2%80%99t%20already%2C%20upgrade%20your%20database%20to%20SQL%20Server%20in%20order%20to%20leverage%20the%20power%20of%20%3CSTRONG%3ESQL%20with%20Access%3C%2FSTRONG%3E%3B%20you%20can%20find%20more%20info%20on%20it%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fsupport.office.com%252Fen-us%252Farticle%252Fmigrate-an-access-database-to-sql-server-7bac0438-498a-4f53-b17b-cc22fc42c979%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C2d314ffc92714382254308d7d33583e4%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637210099127855798%26amp%3Bsdata%3DtptX7n9p6aF%252BsnA1cRyyfOB%252BiWDSH8vJfFUkCjrPLwk%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EHERE%3C%2FA%3E%3A%20please%20note%20you%20may%20need%20to%20create%20SQL%20Server%20views%20and%20stored%20procedures%20based%20on%20the%20complexity%20of%20your%20Access%20database%2C%20and%20although%20occasionally%20timely%2C%20this%20is%20certainly%20a%20worthwhile%20effort.%3C%2FLI%3E%0A%3CLI%3E%3CSTRONG%3EVPN%3C%2FSTRONG%3E%3A%20If%20your%20database%20is%20composed%20of%20both%20Microsoft%20Access%20Front%20End%20and%20a%20SQL%20Server%20backend%2C%20than%20make%20sure%20you%20are%20running%20the%20Front%20End%20file%20on%20your%20local%20PC%20after%20you%20connect%20via%20VPN%20to%20work%2C%20otherwise%20it%20may%20be%20slower%20and%20unreliable.%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%3CSTRONG%3EAbout%20the%20Author%3A%3C%2FSTRONG%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Juan%20Soto.jpg%22%20style%3D%22width%3A%20193px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180722iBC1B3EE457484D79%2Fimage-dimensions%2F193x193%3Fv%3D1.0%22%20width%3D%22193%22%20height%3D%22193%22%20title%3D%22Juan%20Soto.jpg%22%20alt%3D%22Juan%20Soto.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%20style%3D%22margin-top%3A%200in%3B%20background%3A%20white%3B%22%3E%3CSPAN%20style%3D%22font-size%3A%2010.5pt%3B%20font-family%3A%20'Arial'%2Csans-serif%3B%20color%3A%20black%3B%22%3EJuan%20Soto%20is%20the%20President%20of%20IT%20Impact%26nbsp%3Band%20a%20leading%20professional%20in%20the%20industry.%20He%20has%20been%20named%20an%20Access%20MVP%20by%20Microsoft%20since%202011%20and%20is%20a%20frequent%20author%20on%20the%20official%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Fwww.google.com%252Fsearch%253Fsxsrf%253DALeKk02QnNXaF6Pub6_NAwa7jFh58jk7yA%25253A1585616778043%2526source%253Dhp%2526ei%253DipeCXr8Eitv6BNC0mvAI%2526q%253Dsite%25253Ahttps%25253A%25252F%25252Fwww.microsoft.com%25252Fen-us%25252Fmicrosoft-365%25252Fblog%25252F%252B%252522juan%252BSoto%252522%2526oq%253Dsite%25253Ahttps%25253A%25252F%25252Fwww.microsoft.com%25252Fen-us%25252Fmicrosoft-365%25252Fblog%25252F%252B%252522juan%252BSoto%252522%2526gs_lcp%253DCgZwc3ktYWIQA1CwB1iwB2ClCmgBcAB4AIABVYgBVZIBATGYAQCgAQKgAQGqAQdnd3Mtd2l6%2526sclient%253Dpsy-ab%2526ved%253D0ahUKEwi_8bXmwsPoAhWKrZ4KHVCaBo4Q4dUDCAg%2526uact%253D5%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C33bb90bd753e4724616b08d7d5101c76%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637212137547598745%26amp%3Bsdata%3Dory4%252FySuMTVMMptQQfANgfEx%252Bpp12cLQZUjAE0SHlOQ%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22color%3A%20%23ae002e%3B%22%3EMicrosoft%20Access%20blog%3C%2FSPAN%3E%3C%2FA%3E%26nbsp%3Bas%20well%20as%20the%20co-founder%20of%20%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faccessusergroups.org%252F%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C33bb90bd753e4724616b08d7d5101c76%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637212137547608699%26amp%3Bsdata%3DhjC7bYhFHHWijKuCZj8bUhH9UjRhpgaQGnPlsUnaWl0%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CSPAN%20style%3D%22color%3A%20%23ae002e%3B%22%3EAccessUserGroups.org%3C%2FSPAN%3E%3C%2FA%3E%2C%20where%20groups%20of%20Access%20enthusiasts%20around%20the%20world%20meet%20once%20a%20month%20on%20a%20wide%20range%20of%20topics.%20You%20can%20reach%20Juan%20at%20%3C%2FSPAN%3E%3CSPAN%20style%3D%22color%3A%20black%3B%22%3E%3CA%20href%3D%22https%3A%2F%2Fnam06.safelinks.protection.outlook.com%2F%3Furl%3Dhttps%253A%252F%252Faccessexperts.com%252Fcontact%252F%26amp%3Bdata%3D02%257C01%257CEbo.Quansah%2540microsoft.com%257C33bb90bd753e4724616b08d7d5101c76%257C72f988bf86f141af91ab2d7cd011db47%257C1%257C0%257C637212137547608699%26amp%3Bsdata%3D7zScKeN0G%252FSadMv6MXQ%252BOnHlVzLOF3dHKtijx%252BrJ72Q%253D%26amp%3Breserved%3D0%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Faccessexperts.com%2Fcontact%2F%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-1266135%22%20slang%3D%22en-US%22%3E%3CP%3ESee%20how%20you%20can%20work%20with%20Microsoft%20Access%20remotely%2C%20which%20is%20especially%20pertinent%20to%20our%20current%20stay-home%20environment.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Remote.jpg%22%20style%3D%22width%3A%20650px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F180754i8DA176E946CBEB05%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Remote.jpg%22%20alt%3D%22Remote.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1266135%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDesktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Eremote%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESQL%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Evpn%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1284699%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Microsoft%20Access%20to%20Work%20Remotely%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1284699%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Ebo%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewe%20also%20have%20very%20good%20experiences%20with%20Access%202010%20Runtime%2FSQL%20Server%20based%20RemoteApps%20on%20Windows%20Server%20RDSH.%20Relatively%20inexpensive%20License%20Costs%2C%20excellent%20Performance%2C%20Stability%2C%20Scalability%2C%20Security%2C%20Ease%20of%20FrontEnd-Deployment%2FUpdates%20and%20last%20but%20not%20least%20macOS%20and%20even%20Android%20support%20are%20strong%20Plus%20Points%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESince%20we%20will%20soon%20have%20to%20set%20up%20a%20new%20Terminal%20Server%2C%20the%20question%20arises%20whether%20Office%20365%20Access%20Runtime%20is%20officially%20supported%20or%20recommended%20on%20Windows%20Server%202019%20RDSH.%20Is%20it%20as%20robust%20as%20MSI%20Versions%20used%20to%20be%20in%20this%20Scenario%3F%20Are%20there%20any%20Pitfalls%20in%20Installation%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1294682%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Microsoft%20Access%20to%20Work%20Remotely%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1294682%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F389797%22%20target%3D%22_blank%22%3E%40Transimpex%3C%2FA%3E%26nbsp%3B-%20a%26nbsp%3Bcouple%20of%20tips%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ECreate%20the%20Windows%20Server%202019%20RDSH%20as%20a%20virtual%20machine%20hosted%20by%20Windows%20Server%202019.%20This%20makes%20any%20kind%20of%20disaster%20recovery%20or%20farming%20much%20simpler%3C%2FLI%3E%0A%3CLI%3ELet%20the%20RDSH%20VM%20run%20off%20an%20SSD%20formatted%20with%20ReFS%3C%2FLI%3E%0A%3CLI%3EYou%20can%20use%20the%20Access%20Runtime%2C%20but%20if%20the%20users%20are%20licensed%20to%20Office%20365%20(Microsoft%20365)%2C%20this%20can%20be%20installed%20without%20consuming%20one%20of%20the%20user's%20five%20licenses.%20The%26nbsp%3B%3CA%20title%3D%22Office%20Deployment%20Tool%22%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-of-the-office-2016-deployment-tool%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3EOffice%20Deployment%20Tool%3C%2FA%3E%26nbsp%3Bis%20a%20must%20to%20install%20Office%20365%20(Microsoft%20365)%20on%20an%20RDSH%20machine%3C%2FLI%3E%0A%3CLI%3ERename%20your%20frontend.accdb%20to%20frontend.accdr%20to%20make%20it%20launch%20in%20runtime%20mode.%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1296670%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Microsoft%20Access%20to%20Work%20Remotely%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1296670%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20this%20information%3C%2FP%3E%3C%2FLINGO-BODY%3E
Microsoft

Today's post was written by Juan Soto, a Microsoft Access Developer and MVP.

 

Ever wanted to use your Access database remotely? Great news, Microsoft Access can be used remotely under certain conditions, and here are the best ways to do so:

  1. Remote Desktop: The easiest and fastest way to remotely consume your database is through a remote desktop software; from Microsoft’s Remote desktop to other commercial software that will allow you to take over your work PC remotely and continue using the database as if you were in the office (See Get Microsoft Remote Desktop and How to Use Remote Desktop)
  2. If you haven’t already, upgrade your database to SQL Server in order to leverage the power of SQL with Access; you can find more info on it HERE: please note you may need to create SQL Server views and stored procedures based on the complexity of your Access database, and although occasionally timely, this is certainly a worthwhile effort.
  3. VPN: If your database is composed of both Microsoft Access Front End and a SQL Server backend, than make sure you are running the Front End file on your local PC after you connect via VPN to work, otherwise it may be slower and unreliable.

About the Author:

Juan Soto.jpg

 

Juan Soto is the President of IT Impact and a leading professional in the industry. He has been named an Access MVP by Microsoft since 2011 and is a frequent author on the official Microsoft Access blog as well as the co-founder of AccessUserGroups.org, where groups of Access enthusiasts around the world meet once a month on a wide range of topics. You can reach Juan at https://accessexperts.com/contact/

3 Comments
Established Member

Hi Ebo,

 

we also have very good experiences with Access 2010 Runtime/SQL Server based RemoteApps on Windows Server RDSH. Relatively inexpensive License Costs, excellent Performance, Stability, Scalability, Security, Ease of FrontEnd-Deployment/Updates and last but not least macOS and even Android support are strong Plus Points here.

 

Since we will soon have to set up a new Terminal Server, the question arises whether Office 365 Access Runtime is officially supported or recommended on Windows Server 2019 RDSH. Is it as robust as MSI Versions used to be in this Scenario? Are there any Pitfalls in Installation?

@Transimpex - a couple of tips:

 

  • Create the Windows Server 2019 RDSH as a virtual machine hosted by Windows Server 2019. This makes any kind of disaster recovery or farming much simpler
  • Let the RDSH VM run off an SSD formatted with ReFS
  • You can use the Access Runtime, but if the users are licensed to Office 365 (Microsoft 365), this can be installed without consuming one of the user's five licenses. The Office Deployment Tool is a must to install Office 365 (Microsoft 365) on an RDSH machine
  • Rename your frontend.accdb to frontend.accdr to make it launch in runtime mode.

 

Community Manager

Thanks for this information