2
votes
Accepted
Query on a table with lookup columns doesn't work
I want to create a query that updates a field in all items in listA from 'empty' to '1'. The field is not a lookup.
Instead of converting current column field values, you could create a new ...
- 5,277
2
votes
How to delete Lookup columns
Go to: List Settings:
Go to: Columns>search for any lookup columns (See under 'Type' column)>select & delete
- 2,215
2
votes
Can we use Microsoft Access with Microsoft Flow and PowerApps?
PowerApps and Flow are cloud services and has to be able to connect to the data source. There is no Microsoft Access database as-a-service and gateway does not support this kind of on-premise data ...
- 1,651
2
votes
Can we use Microsoft Access with Microsoft Flow and PowerApps?
You can link your Access table to a SharePoint list and then use the SharePoint list in Power Automate (Form) and Power Apps.
External data (Ribbon) -> Import & Link -> New Data Source -> From ...
2
votes
Accepted
Use SharePoint as front end for access
Yes, you can still use it in SharePoint 2016 Enterprise Edition.
Note: In SharePoint 2019, Access Services 2010 and 2013 are deprecated but will remain supported. so that it's recommend to use ...
- 45.3k
1
vote
Accepted
Upload large list (2 mln records) to SharePoint Online, from Access *.mdb
You can write your own simple batch import script in CSOM.
using (ClientContext ctx = new ClientContext("https://some-site-url"))
{
// use proper credentials
List list = ctx.Web.Lists....
- 1,953
1
vote
Capture 'Modified' [Date/Time] on each record in SharePoint
You can use Sharepoint Designer to do this - kick of the workflow when an item is created & modified.
You'd need the workflow to copy the value of the Modified By and Modified Date to additional ...
- 2,215
1
vote
Accepted
MS Access database opens in read-only mode
Access is a strange one; you'd have to download it and open it from your local computer e.g. from desktop. Then you can edit it, save it. Then you'd have to reupload it to Sharepoint. I don't fully ...
- 2,215
1
vote
Accepted
How do I insert fields in a sharepoint list via access? (with choice fields)
I've done a couple of similar "migrations" by:
connecting to SP2010 list from MS Access,
converting the list to
local table (the menu item shown after right click on the list name in All Access ...
- 3,656
1
vote
Can we use Microsoft Access with Microsoft Flow and PowerApps?
In actual fact yes, you can! But it's not a direct link. As Lukas mentioned, Flow and all 365 services are Cloud based. However, there is a magical connector called SQL Server!
You will need to turn ...
- 174
1
vote
How to import data into Excel from MS Access?
Ok. So there are a couple of solutions depending on whether you have SP Enterprise or not.
Enterprise: Use OneDrive for Business (Really nothing more than a SP Library, but hey... it's branded) just ...
- 88
1
vote
SP2010 List Access DB
I needed to right click the link table in the left hand navigation on Access >more options>refresh list to update the field settings in Access
- 21
1
vote
Importing Data into and existing 2013 Sharepoint List
There are multiple causes of the “Cannot update. Database or object is read-only” issue.
Check if there are lookup columns or metadata columns in the SharePoint list.
Remove the lookup columns from ...
- 6,621
1
vote
Accepted
Best way to convert Access Desktop Database for use on Sharepoint 365
What’s the detailed error message you get? Whether you get the error when you upload the database file to library or open the database from library in SharePoint Online?
I can upload a access desktop ...
- 3,968
1
vote
Open with Access grayed out
This was caused in our environment by conflicting Office versions. Designer is only available as a 2013 application. If you install this alongside Office 2016/365, SharePoint will look for Access 2013 ...
- 116
Only top scored, non community-wiki answers of a minimum length are eligible