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
8 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
27 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
35 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
49 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
16 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
10 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
14 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
29 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
29 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
28 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
27 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
19 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
22 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
58 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
59 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
46 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
59 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
169 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
1answer
307 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
25 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
32 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
39 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 ...
0
votes
0answers
16 views

Is it possible to create Microsoft Access report using multiple tables and publish to SharePoint site?

I need to create Microsoft Access report using multiple tables and publish to SharePoint site? Can I know the procedure ?
4
votes
1answer
1k 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
0answers
39 views

Error occurs when creating an app from Access 2013

Installed product: SharePoint 2013 Trial I have read the article in this link http://office.microsoft.com/en-001/access-help/find-a-web-location-for-your-access-web-app-HA103998864.aspx?redir=0 ...
0
votes
1answer
41 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 ...
0
votes
1answer
833 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
31 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
136 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
74 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
593 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
84 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
34 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
19 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
128 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
135 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
65 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
446 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
50 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
567 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
163 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 ...
2
votes
1answer
313 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 ...
1
vote
1answer
2k views

Updating SharePoint List with Linked Access Database - New List Created Instead of Updating Old List

When you've linked an Access Database to SharePoint lists, how do you make sure that saving the database updates the existing list instead of creating a new one, so that lookup columns pull from the ...
0
votes
2answers
479 views

Info Path 2010 read and update accdb with Sharepoint Online

I am new to Sharepoint and to Info Path, so I hope can correctly articulate my goal, here. I would like to use Info Path to distribute forms which read,update and delete records in an Access 2010 db ...
2
votes
0answers
45 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). ...
0
votes
1answer
518 views

List linked to Tables in MS Access: Can't update Lists from Access Only Memo/Text Fields

So I have an Access database where I have re-created the tables as SharePoint lists, and then use the MS Access linked table manager to connect. Everything is fine as it should be, only when I go to ...
0
votes
1answer
99 views

MS Access does not show Name of project owner when linked to Sharepoint lists

I am connecting to Sharepoint through MS Access 2003 and the lists are displayed in Access as linked tables. Everything is fine till here. The list when accessed in Sharepoint site (in browser) shows ...