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
9 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
22 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
26 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
14 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
1answer
42 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
7 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
22 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
14 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
161 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
162 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
20 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
0answers
26 views

SQL Union of two task lists in Access - how to get the correct “Assigned to”?

As you all probably know, a Sharepoint task list has an "Assigned To" column. When I import a task list, I get a table for the list and another table, "UserInfo" with the users for that list. When I ...
0
votes
1answer
357 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
231 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
0answers
224 views

Access 2013 custom web app - Filter Related Items Control

I am looking for a way to filter the related items controls. I have two tables: Categories and Articles The Categories table simply has an ID and Category Name The Articles table has an ID, ...
0
votes
1answer
29 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
0answers
12 views

Sharepoint Designer 2007 Form

I have multiple data fields that I want querried when I submit a form I want to built in Sharepoint designer 07. The tables were built using Access. I tried Infopath however my Sharepoint Server ...
0
votes
0answers
20 views

List as external datasource in Access

Trying to work with a list as an external datasource in Access. I have set up a list and turned on "allow management of content types." We've set up several different content types some of which ...
0
votes
0answers
54 views

Access data in Memo field with append changes (2010 Infopath, SharePoint, Access Environment)

I'm currently using a memo field with append changes checked off to allow column history in a SharePoint browser enabled list form (Infopath). I can successfully get to the data using a linked table ...
0
votes
1answer
87 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
53 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
33 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
21 views

Can I share individual views in Access 365 (using Sharepoint Online) with external users?

I would like to give users of my Access Custom Web App access to only a certain subset of data. The way I am thinking of approaching this is to set up a View for each subset. Is it possible to set ...
0
votes
0answers
45 views

'Invalid signature' in Excel 2007 when trying to open an Excel file

In SharePoint 2010, I'm trying to open an Excel 2007 document, there I get following error: "Invalid Signature". Still the certificate of the user is valid.
0
votes
0answers
88 views

Exporting MS Access Report to Sharepoint Site

I have an MS Access database that contains reports that I would like to export as pdfs and automatically upload to a SharePoint site. Currently, I'm exporting the reports manually and manually ...
0
votes
0answers
109 views

RTE 2501 when using OutputTo to save to a SharePoint 2010 document library, but works fine when saving to local HDD

I have an MS Access 2010 databases that creates a PDF and then saves the file to a SharePoint 2010 document library. This had been working fine for a couple of years, but now I am getting a 2501 ...
0
votes
0answers
58 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
103 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
252 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 ...
1
vote
2answers
607 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
40 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
38 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
49 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
44 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 ...
1
vote
1answer
2k 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 ...
1
vote
1answer
32 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 ...
0
votes
0answers
192 views

Download published accdb (Access Database)

How can you download a database published from MS Access 2010 to Sharepoint 2010? (accdb not the old mdb format). I need to do this inside a python script with no user interaction. There does not ...
0
votes
1answer
88 views

Recommendations, display fields from list in fluid free form

I have a table to store a question/answer checklist. There are thirty five questions, each with a "Yes/No" and then a "Please Elaborate" for each field for when the answer is no that is a multiline ...
1
vote
2answers
779 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 ...
0
votes
1answer
133 views

Add Title field after import from Access

I was imported some list from ms asscess table and I see that dosn't create Title field and user cant watch list item on click in record. How I can fix that without created simular list and transfer ...
0
votes
1answer
36 views

Copy a file from SharePoint and open it on the user's c drive

I would like to copy a Microsoft Access .mde file from a document library to a c drive folder on the user's computer and open it there. Is that possible?
0
votes
1answer
21 views

Making MS Access report tied to SP lists available to SP users

This is SP2010 Server. Got a site with a number of lists. The primary list is a calendar, with a number of related lists tied to it. Using "Open With Access" in the Ribbon, I was able to create a ...
0
votes
2answers
229 views

Updating a backend database from a Sharepoint site?

Okay I'm looking to set up a web based service that for the most part is only used to display data to a number of users. Now initially I'd decided to make something using Sharepoint (2003) as the ...
1
vote
0answers
205 views

Multiple Column Lookup field from Access to Sharepoint

I have two fields called "Tool ID" and "Tool Name" in my main "Tools" table in Access. "Tool ID" is set as the primary key, in that it gives each tool a unique autogenerated number. When I ...
0
votes
0answers
72 views

How can I filter a list that is imported from a MS Access table?

These are the things I have tried already. www.sharepointbinder.com/1/post/2012/02/filters.html request4it.wordpress.com/2012/03/13/filter-a-sharepoint-list-with-jquery/ ...
1
vote
0answers
649 views

Access keeps losing connection to Sharepoint list

I'm setting up an Access 2010 database to have a table that is linked to a Sharepoint list, and I'm experiencing connectivity problems. Whenever I edit a record in the linked table, and then press ...
0
votes
0answers
55 views

Access unable to update singular column in SP list

When I try use Access 2007 to update a linked SharePont table, Access tries to update the entire list rather then the column I specify in my query. Anyone else encounter this problem?
1
vote
1answer
715 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
0answers
189 views

Use an Access Web Database as a data source for Excel?

I have an Access 2010 Web Database published to SharePoint as described here: http://office.microsoft.com/en-us/access-help/build-an-access-database-to-share-on-the-web-HA010356866.aspx If my Access ...