Questions on Access DB

%3CLINGO-SUB%20id%3D%22lingo-sub-1104519%22%20slang%3D%22en-US%22%3EQuestions%20on%20Access%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104519%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Community%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOne%20of%20our%20customer%20raised%20the%20below%20query%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20migrating%20their%20files%20to%20SharePoint%20they%20have%20found%20that%20Access%20DB%20is%20not%20working%20at%20all%20when%20DB%20files%20are%20in%20SharePoint.%20Meaning%2C%20the%20DB%20is%20accessible%2C%20but%20they%20cannot%20use%20access%20db%20via%20sharepoint%2C%20if%20they%20open%20it%2C%20it%20will%20create%20multiple%20access%20dbs%20instead%20of%20just%20changing%20the%20main%20db..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECustomer%20wants%20to%20be%20cloud%20only%2C%20meaning%20not%20using%20any%20servers%20or%20on-prem%20storage.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3ESo%20now%20the%20question%20is%20what%20solution%20can%20we%20come%20up%20with%20to%20resolve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20pointers%20would%20be%20of%20great%20help.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1104519%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1104549%22%20slang%3D%22en-US%22%3ERe%3A%20Questions%20on%20Access%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1104549%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F301435%22%20target%3D%22_blank%22%3E%40Newlife%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20haven't%20looked%20at%20this%20for%20a%20long%20time%20but%20moving%20the%20data%20to%20SharePoint%20maybe%20the%20answer%20%3A-%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fimport-link-or-move-data-to-sharepoint-65bf7b03-74bf-445c-959a-24b7a401ddee%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%3CFONT%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-gb%2Farticle%2Fimport-link-or-move-data-to-sharepoint-65bf7b03-74bf-445c-959a-24b7a401ddee%3C%2FFONT%3E%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAndy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1105092%22%20slang%3D%22en-US%22%3ERe%3A%20Questions%20on%20Access%20DB%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1105092%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F214649%22%20target%3D%22_blank%22%3E%40Andrew%20Hodges%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20prompt%20response.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20could%20be%20a%20solution%2C%20however%2C%20had%20question%20around%20how%20will%20it%20work%20when%20they%20need%20to%20change%20or%20create%20something%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECustomer%20is%20used%20to%20opening%20access%20and%20register%20what%20they%20do%2C%20create%20and%20delete%20things%2C%20they%20need%20a%20solution%20that%20will%20not%20be%20more%20difficult%20for%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20please%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Frequent Contributor

Hi Community, 

 

One of our customer raised the below query:

 

After migrating their files to SharePoint they have found that Access DB is not working at all when DB files are in SharePoint. Meaning, the DB is accessible, but they cannot use access db via sharepoint, if they open it, it will create multiple access dbs instead of just changing the main db.. 

 

Customer wants to be cloud only, meaning not using any servers or on-prem storage.


So now the question is what solution can we come up with to resolve this?

 

Any pointers would be of great help. 

 

 

3 Replies
Highlighted

Hi @Newlife 

 

I haven't looked at this for a long time but moving the data to SharePoint maybe the answer :-

 

https://support.office.com/en-gb/article/import-link-or-move-data-to-sharepoint-65bf7b03-74bf-445c-9... 

 

Andy

 

 

Highlighted

@Andrew Hodges 

 

Thank you for your prompt response. 

 

That could be a solution, however, had question around how will it work when they need to change or create something?

 

Customer is used to opening access and register what they do, create and delete things, they need a solution that will not be more difficult for them.

 

Can you help please?

 

Thanks!!

Highlighted

Hi @Newlife ,

 

LIke I said I haven't used it in a while but you used to be able to import the DB to SharePoint and the data could then be updated via a web interface. It will be a different experience for them, whether they view that as more difficult is open to interpretation.

 

Best suggestion I could give you and what I would do is setup a test site, import the DB, see if you think it is suitable following the instructions in the link and if you think it is a goer then sit down with a suitable user and show them what the option is.

 

Hope that helps

 

Andy