SOLVED
Home

Will my access web app still function correctly after I migrate it to sharepoint lists ?

%3CLINGO-SUB%20id%3D%22lingo-sub-137458%22%20slang%3D%22en-US%22%3EWill%20my%20access%20web%20app%20still%20function%20correctly%20after%20I%20migrate%20it%20to%20sharepoint%20lists%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-137458%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20wondering%20if%20my%20access%20app%20will%20still%20function%20correctly%20after%20I%20export%20all%20the%20tables%20to%20sharepoint%20lists%2C%20while%20I'm%20developing%20flows%20before%20the%20list's%20are%20used%20as%20the%20live%20data.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-137458%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Web%20App%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175597%22%20slang%3D%22en-US%22%3ERe%3A%20Will%20my%20access%20web%20app%20still%20function%20correctly%20after%20I%20migrate%20it%20to%20sharepoint%20lists%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175597%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20are%20talking%20about%20the%20migration%20tool%20on%20the%20page%20of%20your%20AWA%2C%20which%20offers%20to%20migrate%20the%20DATA%20to%20SharePoint%20lists%2C%20then%2C%20yes%2C%20it%20works--at%20least%20it%20did%20the%20last%20time%20I%20used%20it%20several%20months%20ago.%20I%20guess%20I%20ought%20to%20revisit%20that.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHowever%2C%20that%20is%20ONLY%20the%20data.%20Not%20the%20interface.%20You'll%20need%20to%20create%20a%20new%20interface.%20Perhaps%20an%20accdb%20linked%20to%20those%20SP%20lists%20would%20be%20a%20good%20starting%20point.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-175595%22%20slang%3D%22en-US%22%3ERe%3A%20Will%20my%20access%20web%20app%20still%20function%20correctly%20after%20I%20migrate%20it%20to%20sharepoint%20lists%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-175595%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20short%20answer%2C%20as%20Juan%20has%20already%20stated%20is%2C%20No.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20long%20answer%20is%20that%2C%20on%20about%20April%202nd%2C%202018%2C%20your%20existing%20O365%20hosted%20AWAs%20will%20go%20into%20read-only%20mode.%20Period.%3C%2FP%3E%0A%3CP%3EThey%20will%20remain%20in%20read-only%20status%20for%20some%20time%20after%20that%20(I'm%20not%20sure%20how%20long%20that%20was%20supposed%20to%20be).%20Then%20they%20will%20be%20removed%20from%20the%20MS%20hosted%20servers.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20your%20organization%20has%20its%20own%20on-premises%20SharePoint%20Server%20and%20hosts%20your%20AWAs%20internally%2C%20your%20organization%20has%20the%20option%20to%20maintain%20support%20for%20Access%20Web%20Services%20(the%20service%20that%20runs%20your%20AWAs).%20I%20understand%20that%20gives%20such%20installations%20up%20to%205%20years%2C%20or%2010%20years%2C%20depending%20on%20specifics%20of%20licensing%20and%20versions.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20only%20thing%20you%20can%20do%20with%20your%20soon-to-be-late%20AWAs%20is%20retrieve%20your%20DATA%20from%20them.%20The%20interface%20cannot%20be%20rescued.%20You%20will%20need%20to%20a)%20move%20the%20data%2C%20and%20b)%20create%20a%20new%20interface%20for%20it.%3CBR%20%2F%3EWhere%20and%20how%20you%20do%20that%2C%20of%20course%2C%20is%20a%20pretty%20wide-open%20set%20of%20choices.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-171590%22%20slang%3D%22en-US%22%3ERe%3A%20Will%20my%20access%20web%20app%20still%20function%20correctly%20after%20I%20migrate%20it%20to%20sharepoint%20lists%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-171590%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Michael%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20the%20web%20app%20is%20hosted%20by%20Microsoft%20it%20may%20no%20longer%20work%20by%20April%201st%2C%202018%2C%20in%20which%20case%20you%20will%20need%20to%20migrate%20the%20code%20to%20either%20a%20Access%20solution%20or%20another%20web%20solution%20such%20as%20Power%20Apps%20or%20other%20web%20technology.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERegards%3C%2FP%3E%0A%3CP%3EJuan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-139315%22%20slang%3D%22en-US%22%3ERe%3A%20Will%20my%20access%20web%20app%20still%20function%20correctly%20after%20I%20migrate%20it%20to%20sharepoint%20lists%20%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-139315%22%20slang%3D%22en-US%22%3E%3CP%3EHas%20anyone%20attempted%20using%20the%20migration%20tool%20%3F%26nbsp%3B%20Does%20the%20original%20app%20still%20work%20correctly%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Michael Collier
New Contributor

I am wondering if my access app will still function correctly after I export all the tables to sharepoint lists, while I'm developing flows before the list's are used as the live data.

4 Replies

Has anyone attempted using the migration tool ?  Does the original app still work correctly ?

Hi Michael

 

If the web app is hosted by Microsoft it may no longer work by April 1st, 2018, in which case you will need to migrate the code to either a Access solution or another web solution such as Power Apps or other web technology.

 

Regards

Juan

The short answer, as Juan has already stated is, No.

 

The long answer is that, on about April 2nd, 2018, your existing O365 hosted AWAs will go into read-only mode. Period.

They will remain in read-only status for some time after that (I'm not sure how long that was supposed to be). Then they will be removed from the MS hosted servers. 

 

If your organization has its own on-premises SharePoint Server and hosts your AWAs internally, your organization has the option to maintain support for Access Web Services (the service that runs your AWAs). I understand that gives such installations up to 5 years, or 10 years, depending on specifics of licensing and versions.

 

The only thing you can do with your soon-to-be-late AWAs is retrieve your DATA from them. The interface cannot be rescued. You will need to a) move the data, and b) create a new interface for it.
Where and how you do that, of course, is a pretty wide-open set of choices.

Solution

If you are talking about the migration tool on the page of your AWA, which offers to migrate the DATA to SharePoint lists, then, yes, it works--at least it did the last time I used it several months ago. I guess I ought to revisit that.

 

However, that is ONLY the data. Not the interface. You'll need to create a new interface. Perhaps an accdb linked to those SP lists would be a good starting point.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies