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
7 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
18 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
11 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
10 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
15 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
9 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
34 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
23 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
32 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
29 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
29 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
100 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
33 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
42 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
0answers
110 views

“People Picker” field not letting update SP linked table in Access

I have linked a SharePoint list to an Access database in order to manipulate some data. This list contains several fields, including a people picker in which its data come from SharePoint. Once in ...
0
votes
1answer
54 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
45 views

Importing Yes/No Checkbox field into Access

In Access 2010, I have a link to a Sharepoint list. Everything was working swimmingly until I added a Yes/No Checkbox field to the Sharepoint list. It was added recently, so maybe 10% of the list ...
0
votes
0answers
15 views

creating a new “Access Web Database” or publishing an existing Access Database to SharePoint 2010

What are the limitations of either creating a new "Access Web Database" or publishing an existing Access Database to SharePoint 2010? I'm trying to decide if i should publish an existing Db or ...
0
votes
0answers
15 views

Programatically manage Access app in Sharepoint

How can I manage a Sharepoint Access App (MS Access database in Sharepoint) programatically in C# from a remote computer? I want to create, update, delete, read data or even manage the table schema.
0
votes
0answers
57 views

Import Sharepoint list to Access, add columns and export

i want to import sharepoint list (SP 2013) to my Access DB (2013), which works with following code: DoCmd.TransferDatabase acImport, "WSS", _ "WSS;HDR=NO;IMEX=2;" & _ "DATABASE=http://spsite;" ...
0
votes
0answers
35 views

Export List data to MDF Access file?

At one of projects we have SharePpoint 2010 Server, and another independent system that uses Access and *.MDF files. I want to integrate something, and need to export some List data to MDF file ...
0
votes
0answers
28 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
85 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
0answers
60 views

SharePoint MS Access 2013 Web App - How to find the connection string to the sql azure database

I have added an app to from sharepoint store to my sharepoint online.When i login in i can't see the customize in access gear link to get me to the access database. Question 1) How can i get the ...
0
votes
2answers
93 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
76 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 ...
0
votes
0answers
19 views

Import from access with fields that contain user email in office 365 list

I have a list of 5000 records that comes from an excel file. I have reorganised the file so all the data is clean and has the same order of the columns as in the Office 365 / Sharepoint list. To ...
4
votes
2answers
76 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 ...
0
votes
0answers
22 views

Can Access 2010 link to a SharePoint 2010 view?

I link Access 2010 to SharePoint lists all the time. Do some queries on the data and produce some reports. This all works well and fine when I am the one that created the list, mostly because I ...
0
votes
0answers
43 views

Import Managed Metadata from Access

We have some data in Excel that we want to import into a product list (for cross-site publishing) in our site collection. We tried using the import excel app, but the fields are all the wrong name ...
1
vote
1answer
16 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
428 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
484 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
62 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
924 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, ...
0
votes
1answer
512 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
64 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 ...
0
votes
1answer
239 views

access 2013 accesing sharepoint lists hangs, why?

I have downloaded Access 2013 from my office365 account and I'm trying to use it to edit linked lists in a different SharePoint site (not office365), I can create the linked tables but when exiting ...
0
votes
1answer
91 views

Creating Access Apps in SharePoint 2013

I would like to find out more regarding creating Access App in SharePoint 2013 in term of: how far you can customize it? Security level. Is that using SharePoint security or other security? Do i ...
0
votes
2answers
42 views

Querying Published Access 2010 Web Database from SQL Server

I have a published Access 2010 Web Database on my SharePoint 2010 site. The forms and tables all work as expected, but I would like to query this database from SQL Server. Is this possible? ...
0
votes
0answers
87 views

MS Access handling Sharepoint 2010 multiselect peope picker

I have an Access application that I am building to create some reporting. I have all of my lists linked however I have a hiccup when it comes to the people fields. All of the people picker fields are ...
1
vote
0answers
154 views

Ms Access Linking To Sharepoint List

I have a SharePoint list with about 40,000 records * 4 columns I have linked the share point list in MS Access and attempted to run a query selecting all the records in the list into a local table to ...
1
vote
0answers
311 views

Gantt Chart Web Part: '[Column]' already belongs to this DataTable

I ran into an issue in vanilla Sharepoint 2010 where I had a gantt chart set up on a page and another user modified it, forcing me to recreate the chart. I went to connect the new chart to data ...
2
votes
4answers
998 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 ...
1
vote
1answer
63 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 ...
0
votes
1answer
41 views

Importing data to SharePoint list

I have a spreadsheet that I would like to import to a SharePoint list daily. Data changes on it everyday and I need to be able to reflect that. Once an item is added to the SharePoint list, there ...
1
vote
0answers
59 views

Unable to export a report from msaccess to sharepoint list

I need to export a report generated using microsft access to a sharepoint site. I am done with the report. Now when exporting the report to sharepoint list(option was there in access).am unable to ...
4
votes
1answer
2k 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 ...
0
votes
1answer
45 views

Date column changed to Date and Time Column not showing times

I have several lists that need to be changed from Date Only to Date and Time in order to merge the lists in Access and generate reports. I changed the radio button on the column to Date and Time, and ...