Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

All records not showing in access table that is linked to sharepoint list

All records not showing in access table that is linked to sharepoint list

All records not showing in access table that is linked to sharepoint list

I'm getting some bizarre behavior which is causing problems through the Database with queries and forms, etc. One or two of my lists, when viewed as tables when first opening the database sometimes show few or no records though the list has around 2500. I have understood that there may be a problem when the list size gets closer to 5000 and it could very well be that the size is causing the problem. However, I'm noticing that as soon as the list is sorted, the full amount of records show and all database operations function normally involving those lists.

I've seen a thread where someone had a similar problem and each time they refreshed or re-linked the list, all records showed. I think they built a code to automatically refresh the list when a button is clicked or the database is open as a workaround. Refreshing or re-linking the list does not work for me, But sorting does.

1) is this behavior the kind of thing I should expect because of the list size or is there another possible cause?

2) if it is, is there a way of improving the quality of the list somehow through sharepoint?

3) If the only thing that will work is re-sorting, does anyone have a suggestion for a code I can install somewhere to make that happen?

4) Is it time to give up on sharepoint (I hope not) and if so, where do I go next?

Any answers you guys can give would be appreciated.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close