Go Back   Access World Forums > Microsoft Access Discussion > Access Web

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-29-2018, 08:03 AM   #1
aaronb50
Newly Registered User
 
Join Date: Mar 2014
Posts: 185
Thanks: 61
Thanked 2 Times in 2 Posts
aaronb50 is on a distinguished road
Linked SharePoint table missing data.

I have an Access front end with a linked table to SharePoint.

There are only 3 Fields.

Number
Name
REV

Everything is fine for the first 4,500 records. But for some reason, the last few 100 are missing the Number. Its so weird. The items are on SharePoint.

If instead of creating a linked table, I have it create a local table, all of the data is there.

Also the REV field for the whole thing is off. Instead of "A B or C" its placing a number string that I cant seem to figure out where its pulling from. "649587" Just random numbers.

But again, if I make a local copy, all of the data in the REV field is correct.

Anyone have any clue as to what's going on here?

aaronb50 is offline   Reply With Quote
Old 04-03-2018, 08:53 AM   #2
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,411
Thanks: 308
Thanked 180 Times in 160 Posts
NauticalGent will become famous soon enough NauticalGent will become famous soon enough
Re: Linked SharePoint table missing data.

Strange. I have used linked SharePoint lists in the past, with over 75k records, and have not experienced anything like this.

Have you tried converting the list to a local table, deleting the list, exporting the local table back to your SP site and then re-linking?
__________________
“I had the RIGHT to remain silent...but I didn’t have the ABILITY.” - Ron White
NauticalGent is offline   Reply With Quote
The Following User Says Thank You to NauticalGent For This Useful Post:
aaronb50 (04-03-2018)
Old 04-03-2018, 09:15 AM   #3
aaronb50
Newly Registered User
 
Join Date: Mar 2014
Posts: 185
Thanks: 61
Thanked 2 Times in 2 Posts
aaronb50 is on a distinguished road
Re: Linked SharePoint table missing data.

That I have not tried. Thanks for the suggestion.

I'm not sure I have enough permissions to do that. I think I have just enough to link to the table.

I will ask the person holding the keys if they want to give that a shot.

I'm assuming that's going to seem a little risky to them and tell me no. They care way more about their SharePoint then My Access program.

But I will try that if I can convince them to do so.

And if they wont, or it does not work, I have decided to let this go and just refresh the SharePoint table daily to a local access back end and work off of that.

aaronb50 is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Refresh data in Access from linked Sharepoint 365 List AlanC002 General 4 09-04-2017 05:53 AM
Advice on linked tables to Sharepoint data Integrity crann General 0 11-09-2015 04:41 AM
I am having problems to get data from Access while linked with a SharePoint table spdasilv Access Web 0 01-29-2015 09:58 AM
Sharepoint Linked Table Uneditable gunslingor Tables 1 08-27-2013 08:24 AM




All times are GMT -8. The time now is 11:50 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World