%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%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%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%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%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%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%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%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%3CLINGO-SUB%20id%3D%22lingo-sub-1747534%22%20slang%3D%22en-US%22%3ERe%3A%20Getting%20Microsoft%20Access%20to%20Work%20Remotely%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1747534%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%2C%20following%20on%20from%20what%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F52596%22%20target%3D%22_blank%22%3E%40Gustav%20Brock%3C%2FA%3E%26nbsp%3Bposted%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CUL%3E%3CLI%3EWhen%20licensing%20Microsoft%20Office%20365%20for%20use%20with%20Remote%20Desktop%20or%20RemoteApp%2C%20your%20users%20need%20to%20be%20licensed%20for%20a%20subscription%20that%20includes%20Shared%20Computer%20Activation%2C%20such%20as%20Microsoft%20365%20Business%20Premium.%26nbsp%3B%20See%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-shared-computer-activation%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fdeployoffice%2Foverview-shared-computer-activation%3C%2FA%3E.%26nbsp%3B%20You%20must%20also%20install%20Office%20365%20or%20the%20Access%20Runtime%20using%20ODT%20and%20configure%20your%20XML%20configuration%20file%20to%20use%20Shared%20Computer%20Activation.%26nbsp%3B%20On%20top%20of%20Office%20365%20costs%2C%20you%20also%20need%20Windows%20RDS%20User%20or%20Device%20CALs%20and%20Windows%20User%20or%20Device%20CALs%20suitable%20for%202019%20or%20whatever%20version%20you're%20installing%20(though%20you%20likely%20already%20have%20the%20Windows%20CALs).%3C%2FLI%3E%3CLI%3ETo%20prevent%20users%20from%20changing%20the%20VBA%20code%20in%20your%20database%20file%2C%20save%20it%20out%20to%20an%20accde%20file%20so%20that%20the%20VBA%20code%20is%20compiled%20and%20the%20source%20code%20is%20removed...%20then%20as%20suggested%20by%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F52596%22%20target%3D%22_blank%22%3E%40Gustav%20Brock%3C%2FA%3E%2C%20rename%20that%20file%20to%26nbsp%3Baccdr%20to%20ensure%20that%20if%20the%20file%20is%20opened%20by%20the%20full%20version%20of%20Access%20rather%20than%20the%20runtime%2C%20the%20database%20will%20run%20as%20if%20it%20was%20opened%20by%20the%20runtime.%26nbsp%3B%20This%20doesn't%20prevent%20users%20from%20seeing%20your%20local%20and%20linked%20tables%20or%20changing%20the%20contents%20of%20them%20directly%2C%20but%20it%20does%20prevent%20a%20malicious%20actor%20from%20adding%20code%20that%20damages%20your%20systems%2C%20removing%20password%20checks%2C%20taking%20a%20look%20at%20your%20hard-coded%20passwords%20or%20password%20tables%2C%20stealing%20your%20source%20code%2C%20etc.%3C%2FLI%3E%3C%2FUL%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/

4 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

Regular Visitor

@Transimpex, following on from what @Gustav Brock posted,

 

  • When licensing Microsoft Office 365 for use with Remote Desktop or RemoteApp, your users need to be licensed for a subscription that includes Shared Computer Activation, such as Microsoft 365 Business Premium.  See https://docs.microsoft.com/en-us/deployoffice/overview-shared-computer-activation.  You must also install Office 365 or the Access Runtime using ODT and configure your XML configuration file to use Shared Computer Activation.  On top of Office 365 costs, you also need Windows RDS User or Device CALs and Windows User or Device CALs suitable for 2019 or whatever version you're installing (though you likely already have the Windows CALs).
  • To prevent users from changing the VBA code in your database file, save it out to an accde file so that the VBA code is compiled and the source code is removed... then as suggested by @Gustav Brock, rename that file to accdr to ensure that if the file is opened by the full version of Access rather than the runtime, the database will run as if it was opened by the runtime.  This doesn't prevent users from seeing your local and linked tables or changing the contents of them directly, but it does prevent a malicious actor from adding code that damages your systems, removing password checks, taking a look at your hard-coded passwords or password tables, stealing your source code, etc.