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
4
votes
1answer
5k views

Errors executing bulk query when updating a Sharepoint Linked List from Access

I have a Sharepoint list that is a Linked List with MS Access (2010). It has just under 5,000 items (4,864), thus meaning it avoids the reduction in functionality lists of greater than 5,000 items ...
4
votes
2answers
133 views

Access database on Sharepoint 2010

In our company, we have an Access database which is stored in a network shared folder and it is used as a back-end database. And every employee has a front-end version in their own computers. Now we ...
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". ...
3
votes
1answer
15k 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" ...
3
votes
0answers
45 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 ...
3
votes
1answer
771 views

Access Database-linked forms not working after Server Reboot

Our server went down & when I rebooted, all is working on site except Access Database-linked forms are not working. It is showing following error: > Preparing Site ... Someone has recently ...
2
votes
4answers
467 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" ...
2
votes
1answer
12k views

As admin no longer able to "open with access"

I was promoted to site collecton administrator on a sharepoint. Now I cant use the button "open with access" anymore. Previously I was user with read-write and there was no problem with using access ...
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 ...
2
votes
1answer
129 views

How to create a form in infopath hosted in sharepoint

I am looking to create a form in infopath which I will be hosting in SharePoint which in turn will be accessed by the user using a browser. Once the user fills out the form and submits, I want to grab ...
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. ...
2
votes
1answer
2k views

Embedding an Access database in SharePoint?

I have a client who would like me to embed an access database from another location (document library) to a SharePoint page in an editable format. Similar to how you can add the "Excel Web Access" web ...
2
votes
4answers
3k views

List Datasheet view blank

I have a List with some data in it. I can see the data while in standard view however when I switch to Datasheet view I only see a blank datasheet (no headings or data, just the MS Access icon and the ...
2
votes
0answers
58 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 ...
2
votes
0answers
163 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 ...
2
votes
1answer
551 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 ...
2
votes
0answers
162 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 ...
2
votes
0answers
621 views

How SharePoint works with Infopath and an Access database?

I have a database already created in Access. It has a form which uses queries with macros to export an excel with the information chosen from the form. SharePoint would be the perfect tool to share ...
2
votes
1answer
187 views

Why does MS Access 2013 web app dropdown ask to Save when trying to select value?

I have an Access 2013 web app on SharePoint. I have a dropdown list and a button. When a user selects a value from the dropdown and presses the button, a variable is created with the value of the ...
2
votes
1answer
2k views

Error when linking Access to SharePoint library

I wondered if anyone might be able to help with this problem that we have been trying to solve for a couple of weeks. I have a Microsoft Access database which is linked to three form libraries in ...
2
votes
0answers
77 views

Exporting SharePoint lists to access database

I am getting an error message saying I do not have the correct permissions to link a view from my sharepoint site to microsoft access to produce a report (I am the administrator with full control). ...
1
vote
4answers
9k 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
2answers
223 views

Use SharePoint as front end for access

in SharePoint 2010, you could publish an access database to sharepoint and all the forms and reports would show. I read this is being phased out. In SharePoint 2016 , is it still possible to use ...
1
vote
1answer
476 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 '...
1
vote
2answers
2k views

Get Data from Published accdb (Access) Database

I am using Access and Sharepoint 2010. I am writing a python script, which periodically reads tables, checks some conditions, and eventually writes e-mail notifications. I do not have permission to ...
1
vote
1answer
1k views

XSL Style Sheets itemstyle.xsl

I have dynamic image slide show in website sp2010 . the first picture is hyperlink to other website. I found for image in itemstyle.xsl Can I remove (hyperlink for image ) from itemstyle.xsl from ...
1
vote
1answer
2k 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 ...
1
vote
1answer
622 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
1answer
29 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
734 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 ...
1
vote
1answer
40 views

Creating a view of a list with a new column

I have a Sharepoint Linked List, linked to an Access table. I have employee identification numbers among other things stored in this table and created a new column which contained a formula to ...
1
vote
1answer
41 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 ...
1
vote
0answers
235 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
523 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
27 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?...
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
272 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 ...
1
vote
0answers
79 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 ...
1
vote
1answer
230 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
22 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
52 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
20 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....
1
vote
0answers
121 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
6k 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
110 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, ...
1
vote
0answers
115 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-...
1
vote
0answers
94 views

Allow access to enter data , but not full database access

Using Access 2013 or Sharepoint 2013 is it possible to give someone access to data entry forms that work with a back end database whether Access database or Sharepoint SQL. But from everything I've ...
1
vote
0answers
846 views

Can not link data to SharePoint list from Access

I'm working with Sharepoint 2013 & MS Access 2013, till yesterday, everything still good, I click on the button Open with Access, input data, share to site... BUT TODAY, the button Open with ...
1
vote
1answer
29 views

Pull a field from an Access file that is in a Document Library

When an access file is checked into a document library, I need to open it and get an ID field from one of the table and store the ID in the list. Any help is greatly appreciated.
1
vote
1answer
966 views

Problem loading backup Access App, "The provided App differs from another App with the same version and product ID"

This relates to an Access App that I designed in Access 2013 and was hosted on my institution's Microsoft Office 365 / Sharepoint site. I had saved a version of the app for backup, which created an *....