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 ...

learn more… | top users | synonyms

0
votes
0answers
13 views

Viewing Form Library Fields in Access

I'd like to use MS Access to do some reporting on my SharePoint Form Library that was created from Infopath. When I set up a connection to the form library (from Access) I cannot seem to get Access ...
0
votes
0answers
20 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 ...
0
votes
0answers
15 views

List of all documents in a 2010 Sharepoint using Web Services

I have been tasked to find all the documents in a 2010 SharePoint site. I also need to identify the "Modified By and Date" of each document. I am using 2010 Access and coding in VBA. I have tired ...
1
vote
0answers
24 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. ...
0
votes
0answers
9 views

Export from Access 2013 to SharePoint 2013 failed because Name column inserted by default

For Access 2013, you can export a table as a SharePoint list. I was able to export fine to a SharePoint 2010 site, and export to a SharePoint 2013 Foundation site. However, when I tried to do it to a ...
2
votes
1answer
30 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
22 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 ...
0
votes
0answers
42 views

Have contribute rights, but list is still Read-Only

If I'm trying to update a SharePoint List with Access, I get the following message: "Cannot update. Database or object is read-only." I've ensured that I've contribute rights to this list, ...
2
votes
0answers
42 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
67 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
0answers
16 views

Use BCS to Connect to Access Database Stored in a Document Library

If I copy an Access database file into a document library (I presume this is possible), can I set up a Business Connectivity Services connection to it (within the same site) so I can manage the tables ...
0
votes
0answers
15 views

UPN change made my data dissapear

I have a user that has recently had his UPN changed from "initials""companyname".com to "initials""company"-"name".com He has persissions to use Acsess and he had opened and edited the data through ...
0
votes
0answers
15 views

The database collation is not supported error message when creating new Access web app to Sharepoint Online

I'm currently on a O365 Business Premium trial. I've setup a Sharepoint site, and now I'm trying to create an Access web app. When I create the web app using "Custom web app" tile from Access' main ...
0
votes
0answers
16 views

Sharepoint online (plan2), number of available users to access database application?

I have bought Sharepoint online (plan2). I plan to use it mainly for my access database. Idea is that total 10 users can login to sharepoint and edit/view data. I am confused because I can't find ...
0
votes
0answers
18 views

How to determine if the request.urlreferrer is coming from word document

I have a SharePoint project which captures where the referrer is coming from. How to capture if the referrer is from word document link?
0
votes
1answer
47 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
0answers
65 views

Sharepoint Online Microsoft Access

I am trying to move my MS Access tables to my SharePoint site on Office 365. I can log on to the SharePoint site with the user id and password, no problem. However when I attempt to export "tables" ...
0
votes
0answers
31 views

Export to database Failed

I'm using SharePoint 2010 and MS Access 2010. When I click the "Open With Access" button for a list in SharePoint in get following error message -I'm using Access 2010 32 bit, SharePoint 2010 and ...
0
votes
0answers
158 views

MS Access “Cannot connect to the SharePoint site” Error on Large Linked Lists

I am having an issue with MS Access 2010 opening a large SharePoint linked list. It was working fine on a Friday afternoon around 4:30pm, but then, the following Monday morning, I began getting an ...
0
votes
0answers
44 views

Using an Access Database to link SharePoint online to on premise SQL

I know there are ways to connect SharePoint Online to on-prem SQL using Visual Studio and other programmatic solutions. I am looking for a no-code solution. I am wondering if this is even plausible: ...
0
votes
1answer
75 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
0answers
10 views

Link an Access Contact List to a Sharepoint list which Syncs with Outlook

This is my first post and I am not an expert. I have some understanding of access databases and am getting confused and mixed responses from Sharepoint Consultants. I have a table called "Contacts" ...
0
votes
0answers
36 views

SP 2010 use table data from Access 2010 web database in a SharePoint web part

I've attempted for days now to create some mechanism in the MS SharePoint MS Access 2010 ecosystem that will enable the use of either: create SP List, import a link to the SP list into the Access ...
0
votes
0answers
72 views

Cannot create Access app package in Sharepoint 2013

I've created an Access app on my Sharepoint site but I'm trying to create a package so I can add it to a site page so I can tailor the permissions. When I try to save as a package in Access, I get ...
0
votes
0answers
169 views

The RunDataMacro action failed to invoke a data macro on the Server. Please check your connectivity to the server

I have a created a SharePoint site by selecting >Site Actions>View All Site Content, established from an MS Access template web database called “Projects web database”. I am not an administrator, I ...
0
votes
0answers
21 views

SharePoint 2013 Services and Access datasheet form issue

I'm currently running a solution based on SharePoint 2013 services. I've created an Access database (Access 2010) incl. a few tables, very simple queries and datasheet forms. Everything seems to be ...
0
votes
0answers
53 views

Linked Excel to Access and then to Sharepoint

I don't know if it's possible, but I'm asking the question anyway. I have a "master" Excel file where the data is located. The "main" interface is quite complex. Basically, it's a calendar to keep ...
0
votes
0answers
11 views

Show Access File at SharePoint 2013

I want to show access file, at the SharePoint 2013. Users can show the file and edit, like excel file. How can I do this?
0
votes
0answers
221 views

Access Services is unable to process the request SharePoint 2010

I am getting an error on our intranet when a user tries to open an access based 'projects' database. When you try to open the access db you get the following error "Access Services is unable to ...
0
votes
0answers
73 views

Access 2013, fields missing from linked List

I'm preparing an Access 2013 Web App, I've linked several SP2013 lists and they work fine except for a list with 13 columns. Two of the fields don't show in Access: a Short Text column and a ...
0
votes
1answer
107 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 ...
0
votes
1answer
19 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
36 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
83 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
131 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, ...
1
vote
0answers
49 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
188 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 ...
0
votes
1answer
125 views

Export Access table to SP with display control Combo box

I have table in MS Access, that has following lookup properties: Display control: Combobox Row source type: Value list Row source: "Option 1";"Option 2";"Option 3" And I want export this table to ...
0
votes
0answers
36 views

SharePoint list open in access

I have a SharePoint list that I'm connecting to Access for editing. All of the single line of text fields show up but the choice fields do not, these are not multiple choice just single choice ...
1
vote
0answers
312 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 ...
0
votes
2answers
152 views

Ms Access Web DB (Access Services) GotoControl functionality broken

I am developing a web database in Access 2010 and uploading it to our Sharepoint 2010 server. I found a bug in a simple macro command that only exists in SharePoint. The command is "Gotocontrol" in ...
2
votes
1answer
218 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 ...
4
votes
2answers
83 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 ...
1
vote
1answer
20 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.
0
votes
0answers
763 views

SharePoint 2013 Access Services can't add app

I setup Access Services in my Farm with the help of the official Microsoft whitepaper. http://www.microsoft.com/en-us/download/details.aspx?id=30445 The setup worked fine but when I try to add an ...
1
vote
1answer
671 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 ...
0
votes
0answers
121 views

How to delete a table that is corrupted when copying another table in Access Web App?

This question is specific to an Access Web App, hosted on my institutional Sharepoint / Office 365 account. I copied a table, "Equipment" by dragging and dropping it using the Navigation Pane in the ...
0
votes
1answer
1k views

VBA - copy folder - checkout required

I'm using an access database to generate a folder full of files. I want to copy the folder to sharepoint. I'm trying to do this by programmatically mapping the sharepoint library to a network drive, ...
1
vote
1answer
800 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 ...
0
votes
1answer
132 views

Datasheet View Lookup on Calculated Column String;#

Found many posts on the internet but none adressing this scenario: The machine has Office 2010 64bit, which means that "2007 Office System Driver: Data Connectivity Components" had to be installed in ...