Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
1answer
18 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
29 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
43 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 ...
0
votes
1answer
167 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
42 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
105 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 ...
1
vote
0answers
40 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
19 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
38 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
82 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
109 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
1k 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
20 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
25 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
126 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
543 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
50 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
14 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
165 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
2k 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
38 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
131 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
140 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
20 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
49 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
263 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
417 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
270 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
79 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
107 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
88 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
266 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
10k 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
312 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
112 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
35 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
85 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
278 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
1k 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 ...
0
votes
1answer
290 views

Add Access File on SharePoint Designer 2013

How can I add .accdb file on SharePoint Designer 2013? I looked blocked file types on Central Administration but I didn't find accdb and I didn't remove from the list. When I create new access app ...
0
votes
1answer
24 views

How to show “edit in access” button

how to add the "Edit in Access" in the Ribbon? Currently, the Ribbon has the following: Export to Spreadsheet, View RRS Feed, Alert Me. thanks
3
votes
0answers
42 views

How to interact with Access DB hosted on Sharepoint Online via Public Website?

I have data in an Access DB which is hosted on Sharepoint Online. I would like to build a website where users can query the DB via an interface that I can style via HTML and CSS. I am a brand new ...
0
votes
1answer
573 views

Possible to upload an Access 2013 DB to SharePoint 2013 online?

I have an Access 2013 database I've been working on. It's not a web app or anything. Just a normal ol' accdb file. I'm using Office 365 so I have SharePoint online. Is it possible to get this ...
2
votes
4answers
429 views

Error when trying to open list with “Open with Access” option

SharePoint 2010 Enterprise with SP2 installed. We have a standard OOTB SharePoint List and are trying to "Open with Access" The problem is when we click the "Open with Access" button in the ribbon, ...