Access: remote access, sharing, OneDrive, etc.

%3CLINGO-SUB%20id%3D%22lingo-sub-1469640%22%20slang%3D%22en-US%22%3EAccess%3A%20remote%20access%2C%20sharing%2C%20OneDrive%2C%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469640%22%20slang%3D%22en-US%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20imagine%20the%20questions%20I%20have%20have%20been%20asked%20ad%20nauseam%2C%20but%20I%20haven't%20been%20able%20to%20find%20a%20solution%2C%20yet.%20So%20here%20I%20am.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20understand%20clearly%20that%20it's%20not%20a%20good%20idea%20to%20save%20an%20access%20back-end%20on%20OneDrive%20or%20a%20SharePoint%20library%20for%20several%20users%20because%20of%20sync%20issues.%20Is%20there%20a%20solution%20besides%20the%20local%20network%3F%20In%20my%20job%20we%20have%20all%20moved%20to%20OneDrive%20and%20SharePoint%2C%20and%20we've%20been%20informed%20network%20drives%20will%20be%20removed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20relatively%20easy%20solution%3F%20I'd%20rather%20avoid%20getting%20into%20Azure%20and%20developing%20pages%20to%20access%20and%20manage%20data%2C%20if%20I%20can%20find%20a%20solution.%20What%20about%20PowerApps%20(though%20I'm%20not%20familiar%20with%20them%20yet).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3ELeonel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1469640%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470695%22%20slang%3D%22en-US%22%3ERe%3A%20Access%3A%20remote%20access%2C%20sharing%2C%20OneDrive%2C%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470695%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F216718%22%20target%3D%22_blank%22%3E%40Leonel%20GUZMAN%3C%2FA%3E%26nbsp%3BIf%20you%20move%20the%20back%20end%20from%20an%20Access%20accdb%20to%20a%20hosted%20SQL%20Server%20database%2C%20which%20could%20be%20Azure%20as%20well%20as%20one%20of%20a%20number%20of%20other%20hosting%20services%2C%20you%20can%20continue%20to%20use%20the%20same%20Access%20Front%20End.%20No%20need%20to%20create%20a%20new%20interface.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20DOES%20require%20some%20design%20changes%20in%20Access%3CSTRONG%3E%3CEM%3E%20in%20some%20cases%20%3C%2FEM%3E%3C%2FSTRONG%3Ebecause%20there%20are%20traditional%20approaches%20in%20Access%20that%20don't%20work%20well%20in%20other%20environments.%20You'll%20also%20find%20some%20other%20modifications%20may%20be%20required.%20Overall%2C%20though%2C%20it%20works%20very%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20find%20%3CA%20href%3D%22https%3A%2F%2Frogersaccessblog.blogspot.com%2Fsearch%2Flabel%2FProblems%2520With%2520Repeated%2520Columns%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ea%20lot%20of%20basic%20information%20here.%26nbsp%3B%3C%2FA%3E%3C%2FP%3E%3CP%3EThis%20presentation%20has%20been%20around%20for%20a%20long%20time%2C%20but%20is%20still%20relevant.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470705%22%20slang%3D%22en-US%22%3ERe%3A%20Access%3A%20remote%20access%2C%20sharing%2C%20OneDrive%2C%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470705%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F216718%22%20target%3D%22_blank%22%3E%40Leonel%20GUZMAN%3C%2FA%3E%26nbsp%3BPowerApps%20are%20limited%20in%20many%20ways.%20It%20may%20be%20that%20they%20can%20be%20useful%20as%20adjuncts%20to%20your%20full-feature%20desktop%20applications%2C%20especially%20for%20remote%20users.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470965%22%20slang%3D%22en-US%22%3ERe%3A%20Access%3A%20remote%20access%2C%20sharing%2C%20OneDrive%2C%20etc.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470965%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F46682%22%20target%3D%22_blank%22%3E%40George%20Hepworth%3C%2FA%3E%26nbsp%3BThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20fact%2C%20I%20haven't%20prepared%20the%20database%20yet%2C%20and%20I%20have%20a%20bit%20of%20time%20(need%20it%20in%20January%20next%20year)%2C%20so%20I'll%20explore%20using%20Azure.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20again%3C%2FP%3E%3CP%3Elg%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hello

I imagine the questions I have have been asked ad nauseam, but I haven't been able to find a solution, yet. So here I am.

 

I understand clearly that it's not a good idea to save an access back-end on OneDrive or a SharePoint library for several users because of sync issues. Is there a solution besides the local network? In my job we have all moved to OneDrive and SharePoint, and we've been informed network drives will be removed.

 

Any relatively easy solution? I'd rather avoid getting into Azure and developing pages to access and manage data, if I can find a solution. What about PowerApps (though I'm not familiar with them yet).

 

Thank you

Leonel

3 Replies
Highlighted

@Leonel GUZMAN If you move the back end from an Access accdb to a hosted SQL Server database, which could be Azure as well as one of a number of other hosting services, you can continue to use the same Access Front End. No need to create a new interface.

 

That DOES require some design changes in Access in some cases because there are traditional approaches in Access that don't work well in other environments. You'll also find some other modifications may be required. Overall, though, it works very well.

 

You can find a lot of basic information here. 

This presentation has been around for a long time, but is still relevant.

Highlighted

@Leonel GUZMAN PowerApps are limited in many ways. It may be that they can be useful as adjuncts to your full-feature desktop applications, especially for remote users. 

Highlighted

@George Hepworth Thank you!

 

In fact, I haven't prepared the database yet, and I have a bit of time (need it in January next year), so I'll explore using Azure.

 

Thank you again

lg