Questions tagged [microsoft-access]

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

Unable to add an Access app

I am trying to add an Access App to my Sharepoint site on Sharepoint Server 2016 but it gives me the following error: "Sorry, something went wrong. An unexpected error has occurred." I have full ...
0
votes
0answers
16 views

Why is my linked Sharepoint List in MS Access not showing everything?

When I link to a Sharepoint list in MS Access, it doesn't show me everything in the list. However, when I import the same list it does show me everything. When importing a list there is an option to ...
0
votes
0answers
83 views

Create Sharepoint Online folder from VBA (access 2016)

I am a newcomer to SharePoint Online and I am trying to add a subfolder to a SharePoint Document Library from Access 2016 using VBA. This recent post seems to be exactly what I need: https://...
0
votes
1answer
69 views

Upload large list (2 mln records) to SharePoint Online, from Access *.mdb

I try to migrate records from Access database to SharePoint list (about 2 millions records). I go to "External" tab, then "More.." and there is "Export to SharePoint list". It failed after about 15'...
1
vote
1answer
26 views

How to add an editable Access Desktop Database to Sharepoint Server 2016

I'm a university student summer intern at a government agency, so sorry if this comes off as a dumb question or if I don't appear very knowledgeable, but our team of maybe 10-ish people uses an excel ...
0
votes
1answer
147 views

Capture 'Modified' [Date/Time] on each record in SharePoint

I have a Custom list in SharePoint. This list contains up to 5000 records at any given time, for employees to go in to rate each record. I want to do an analysis on when records were modified and by ...
1
vote
1answer
636 views

MS Access database opens in read-only mode

I have an Access database (format .accdb) in my Documents directory in my Sharepoint Online instance. When I open the file, MS Access loads but it opens in read-only mode, showing the following: If ...
0
votes
0answers
6 views

export from MsAccess(sharepoint) to Word form

I am looking for some days for a solution for my issue: - i have sharepoint list with more colums ( called "all items") - i have a word form ("format.doc") to complete with information from columns (...
1
vote
1answer
200 views

How do I insert fields in a sharepoint list via access? (with choice fields)

I'm trying to import a year's worth of data from an 2010 sharepoint server list to a new 2016 sharepoint server list: I've built the 2016 list to mirror the 2010 list design, and linked to both from ...
1
vote
4answers
3k views

Can we use Microsoft Access with Microsoft Flow and PowerApps?

I want to use Microsoft Access database with the Microsoft Flow and PowerApps. Is it possible to do? If yes then how? Thanks.
1
vote
0answers
103 views

Problem with Microsoft Access Database linking to a SharePoint list?

I have a few SharePoint lists as the back end to several different Access Databases - each used by different people for different tasks so different queries and different forms as required. One ...
1
vote
0answers
293 views

Understanding Access's automagic authentication to SharePoint Online

I'm trying to automate SharePoint tasks from Microsoft Access using the REST API (since the CSOM is not available in VBA). This, however, requires me to authenticate. I usually authenticate to ...
2
votes
0answers
46 views

Access Database exceeds 5000 items and doesn't function in SharePoint because of that

I have a table in Microsoft Access that contains much more then 5000 items. In addition, I created a MS access form which I published in SharePoint. In this form, the users have to select some options ...
1
vote
0answers
22 views

Seeing Version column in Access linked list

I've turned on versioning for the list. It shows in the SharePoint List. However when I link the list to my Access database the Version column isn't showing up. All the other columns do. Thoughts?...
0
votes
1answer
93 views

How to import data into Excel from MS Access?

If I put an MS Access database on Sharepoint or One Drive, how can I import/link the database table into Excel? My Excel will also eventually be on Sharepoint. Current as a PoC, I put the database on ...
1
vote
1answer
434 views

Problems using office365 Sharepoint Lists as backend for MS Access 2016

i'm completely new to sharepoint. I had a fairly complex Access 2016 database where there was a "backend" Access database with 15 tables, a Access "admin" frontend with lots of queries for reporting, ...
1
vote
1answer
303 views

Query on a table with lookup columns doesn't work

What I have I've got 2 lists (listA, listB). In listA there are several lookup columns to listB. What I want to do I want to create a query that updates a field in all items in listA from 'empty' to '...
0
votes
1answer
2k views

Connect excel to access to Sharepoint

Im trying to sync excel and Sharepoint so I can update an excel table and changes appears in sharepoint. Since I’m using 2016 versions for excel and Sharepoint I noticed it’s not as easy because I ...
0
votes
1answer
40 views

Will deleting a table in an Access 2010 Database delete the List from SharePoint 2010 Server?

I'm attempting to use this fix to recover missing fields that aren't appearing in Microsoft Access I'm not sure if what I'm doing is deleting the link or deleting the list entirely. I'm right ...
0
votes
0answers
26 views

Open with Access not working due to list permissions error

I'm trying to open a SharePoint 2013 list with Access 2013 which gives me the following error: The list has unique permissions and the items within it have item level permissions. Summary of my ...
1
vote
0answers
18 views

Access for external employees suddenly no longer possible

external is added to list and does not appear in this list. the external had already accessed and was able to edit the documents, etc., this access was suddenly no longer possible for no apparent ...
1
vote
0answers
175 views

Sharepoint Linked Table Problems when using Microsoft Access

So here is my situation. I have 2 sharepoint sites which I am currently a member of the "Owners" permission group: https://mysite.sharepoint.com/ (root site, so I would like to avoid putting ...
0
votes
3answers
1k views

How to delete Lookup columns

I have a list with more columns in SharePoint Online 2010. When I am making the extraction to Access or Excel, I have some columns which do not appear in my list of columns I created. I can see them ...
0
votes
1answer
63 views

Sharepoint newsfeed image authorization

I want to display images which are in my organization SharePoint news feed page in a xamarin app. Image URL needs an authorization. How to give this authorization. Image URL : "https://...
1
vote
1answer
17 views

SP2010 List Access DB

I have an problem with a SharePoint list and an Access DB. They are one in the same however the problem I am having is that the field types do not seem to add up. In Access when I go to design mode ...
1
vote
1answer
353 views

Importing Data into and existing 2013 Sharepoint List

I have been using this process for quite a while and while it is a bit cumbersome it has always worked SharePoint 2016 Access 2013 Excel 2013 Open Access Create ne DB External Data Connect to ...
2
votes
1answer
3k views

Best way to convert Access Desktop Database for use on Sharepoint 365

I currently have an Access Desktop Database stored on a network folder, however we are setting up a customer facing SharePoint Online 365 site and would like users to launch the database through this. ...
1
vote
0answers
60 views

Items in SharePoint list missing under different access scenarios

I have a custom SharePoint list which is configured to hold two content types: folder (added automatically but never used) and item. List settings are pretty much default. Specifically, there is only ...
2
votes
0answers
151 views

Migration data from Access database to Sharepoint online

First Approach: I have Microsoft access database which has multiple relationships within a table. I have tried to import data into SharePoint list but an issue is that every time it is creating a new ...
1
vote
1answer
190 views

Items missing when accessing list in Access database

I have an Access database which stores its data in SharePoint lists. The .accdb file resides on the SharePoint site itself. The lists are meant to be accessed only via the Access database (I went for ...
1
vote
0answers
21 views

SharePoint list exported from access always shows datasheet list view web part

I have exported data from the access table to SharePoint 2010 list. I have created different views of the same list and want to put on the Site Page. When I am adding the list view web part to the ...
1
vote
0answers
50 views

Populating data in sharepoint - long term

I am working on a data project that involves entering some data and indexing them. I have been considering doing the data entry in excel, access, and directly on Sharepoint. Entering data directly ...
1
vote
0answers
18 views

Issue updating newly added multi-valued lookup field

I have a lookup list ‘Products’ which had two fields as follows GroupLvL1 ItemNumber The values in GroupLvL1 can be repeated but those in products must be unique. The list below should give the idea....
0
votes
1answer
409 views

Read/Write permission for SharePoint list in Access 2013

I have been using Access web Apps for some time but now need to move to SharePoint list. I have all lists in place and have created new Access DB to sync with the list imported from the Azure database....
0
votes
1answer
545 views

Make “Modified By” and “Modified” specific to a column or set of columns / use SPListItem.SystemUpdate

I have queries that I will schedule to run daily to update a sharepoint list linked to an access database. The problem is any time these queries update the list, it logs modified by and modified date ...
2
votes
1answer
407 views

Updating SharePoint(2010) List from Access 2010 - Error Executing Bulk Query

I've been having an issue running this query in an Access 2010 application. The issue arises when the end-user clicks a button that executes this query. UPDATE [Renewal Stop Request] SET [Renewal ...
0
votes
1answer
98 views

Sharepoint busy and preventing Access writes

I am from an Access VBA background and unfamiliar with SharePoint. I have a query which writes to a SharePoint List, which was set up in Access using the wizards in Access 2010. The wizard creates a ...
1
vote
0answers
114 views

Programmatically Work With Access Database On Sharepoint

I know that it is possible to upload Microsoft Access Databases to a Sharepoint server. I am needing a way to store a large amount of data on Sharepoint so that I can use it to to customize parts of ...
1
vote
1answer
5k views

MS Access 2016 using SharePoint lists as tables – Access crash issue

We are using Access 2016 and SharePoint (our Office 365 package). I have built a 7 table Access database and made these tables linked to SharePoint lists (the tables in Access show as the yellow icons)...
1
vote
0answers
94 views

Write Conflict Error with SharePoint Linked Tables in Access 2010

Using Access 2010 and SharePoint 2013. I linked Share Point 2013 list with Access 2010, this was working fine but started seeing conflict error this morning. It works fine after I refresh the list, ...
0
votes
1answer
349 views

SharePoint 2013 import data from Access

I am trying to build a DR application to a SharePoint site using Access 2013. This Access DB will be available when the SP site goes down. and once the SP site is up, all items created in Access DB ...
2
votes
1answer
12k views

Open with Access grayed out

I cannot use the functionality "Open with Access" on a SP list. I recently installed SharePoint Designer and that seemed to cause the problem. I navigate to the list and can see the "Open with Access" ...
0
votes
1answer
369 views

Performance Issue - Using Access to Update Field in SharePoint

I would like to use MS Access to update one field on a SharePoint list. I run into serious performance issues with MSAccess locking up for +15 minutes. Are there steps I can take to optimize the query ...
1
vote
0answers
114 views

Why am I unable to create a web database with Access?

In these in instructions this video when it gets to about 0:20s in I get a pop-up saying I don't have permissions. https://support.office.com/en-US/article/Build-and-publish-an-Access-database-to-...
2
votes
1answer
54 views

How to populate Excel 2013 sheets in SP2013 library with data from Access database on SP2013?

I'm new to Sharepoint. I may not use the right terminology and sound like an idiot. Please be kind. (I'm a former JEE developer. I understand the basic concepts. Just not sure how to translate them ...
0
votes
1answer
38 views

MS Access to Sharepoint: One user gets '3073 Unupdateable Query'

I have a couple MS Access 2010 tools that are frontends with SharePoint lists as the backend. They work fine for all users but one. When he clicks a button I made, it runs a couple queries to update ...
2
votes
0answers
108 views

How do I determine why some records within my SharePoint list are read only?

I'm running a snippet of code to update my SharePoint List through Access 2013. It seems that my code works for some records, but other records will give me the "Cannot update. Database or ...
3
votes
1answer
2k views

Editing a Sharepoint 2010 List record with Access 2013 - “Cannot Update. Database or object is read-only”

I've got kind of a weird problem, and I haven't been able to find an answer. I'm accessing a sharepoint list through Access, and I'd like to change a "status" field from "pending" to "complete". ...
0
votes
1answer
287 views

Change Access Services Database Name

We are trying out access services for SharePoint and noticed that it generates its own db_<guid> database in the SP database server. We were wondering if it is possible to rename the database ...
0
votes
1answer
2k views

Prevent “Save to SharePoint Site” alert in Access 2010

We are storing an Access 2010 file in a SharePoint 2010 library and the yellow alert bar that says "Save to SharePoint Site" is showing up whenever users open the Access file. If the user closes the ...