473,612 Members | 2,129 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access Linking to SharePoint not showing all columns

anoble1
245 New Member
I have a blank Access DB where I am adding a data source link to SharePoint. After I link I choose everything I want to bring over. However, when I do that I see all the items from the site with exception of a few columns. When I open the design of the SharePoint Table in MS Access I can see the column is there, but it is skipped when I look at it in data view. What can cause this?
Jul 19 '23 #1
2 19838
NeoPa
32,566 Recognized Expert Moderator MVP
Hi anoble.

There are a number of field types that don't show up when linked to Access. Is it an Attachment field? Or maybe some other type not supported to show directly from an Access datasheet?

PS. My SharePoint experience is limited so I can only say what sort of thing to look out for.
Jul 19 '23 #2
Nauticalgent
100 New Member
anoble1,

Did you ever get this sorted?
Aug 1 '23 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
840
by: Amber | last post by:
The DataGrid allows you to make columns visible or invisible on demand - even edit and other special columns. This article will show you how it is done. Some developers have reported problems controlling the visibility of columns in the DataGrid control. The problem usually comes down to one fact. The DataGrid has a property called AutoGenerateColumns. The default value is "True". This means that when AutoGenerateColumns is set to True,...
4
3476
by: James Beswick | last post by:
I have some linked tables that connect to a Sharepoint site, but every time they are reconnected they prompt the user for a username/password. I would like to embed the login into the application, just as you can for any other type of linked table, but I can't find a way to do this. Do anyone have any idea how to fix this? Also, this is new to me, so anyone has any experience of how well Access and Sharepoint perform together, I'd love...
2
1639
by: =?Utf-8?B?Sm9zaCBTY2htaWR0?= | last post by:
I have a gridview that is being used for managing inventory. The default view shows the stock currently available. When editing I don't want the stock to be directly edited, rather the user will enter the amount of items being added/removed. When the user clicks the 'Edit' link I want to hide the stock column and display a field for the TransactionAmt. I'm using the RowUpdating event to execute some functions used by that field. I've...
6
2787
isben22
by: isben22 | last post by:
I am a beginning developer using ACCESS 03 and Share Point Portal 2003. I have a list of events with start and stop dates in SharePoint that I want to pass to and Access Data Base. Ultimatly I want to create an itinerary program that has an event and many subEvents as in a relational database. But I have not been able to find information to show me how to turn a SPS List into a relational table. I have now linked to the SPS List, and...
0
1061
by: Paul Watson | last post by:
Has anyone successfully accessed a Microsoft SharePoint WSS using Python? No, not IronPython. I need for this to be able to run on all machines the customer might choose. Which libs are you using? ZSI, SOAPpy, soaplib, ??? http://wiki.python.org/moin/WebServices
0
1184
by: JensenKragh | last post by:
Hi, I have a ms access report (and som forms) which display pictures by linking to their folder paths. These pictures are to be moved into a sharepoint site - how can I link or embed these pictures stored in the sharepoint site on my reports? BR Thomas
0
1554
by: jxt1303 | last post by:
I've created an Access 2007 application that has linked tables in a SharePoint 2007 site. Normally, after I open the app and access a form that uses one of these linked tables, you are prompted for a user name and password by SharePoint, which works fine. But sometimes, it won't automatically prompt you for a username and password, instead it will say there is a Network/IO error. What I am trying to do is make the application prompt you...
4
3900
by: VBnewb13 | last post by:
Hello everyone, This might not be the appropriate thread but I'm looking for some bigtime help and this is the closest subject I could find :P My problem deals with Excel, Sharepoint, and Access all in one. I will try to detail it as best as I can. To start, I have an Access Database containing some forms and 3 tables. These 3 tables are linked to 3 Excel spreadsheets. The main purpose of this database is to act as a search form that...
1
1267
by: manikandanc | last post by:
if i tying to insert the values in access table not showing any error but also not saving the values in table. plz,Help.
0
8105
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
8605
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8565
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
6076
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5532
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4109
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2550
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1695
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
1413
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.