By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Linked Table to Sharepoint List - SLOW

P: 33
I have a couple tables linked to Sharepoint Lists. All queries on these tables run very slowly. Is there a faster way to access these tables? I'm afraid my users will give up and End Task the Access database (never a good thing) while it is still running update and delete queries. Not sure if anyone knows a way to streamline the process, for instance, can I delete any of the columns that Sharepoint automatically adds to each table? Is it faster to run SQL statements from VBA or create and run Access Queries from VBA?

Thanks!

-Kyle
Jul 21 '09 #1
Share this Question
Share on Google+
2 Replies


puppydogbuddy
Expert 100+
P: 1,923
This has been frequently discussed in the public forums. See this link:

http://sharepoint.microsoft.com/blog...RootFolder=%2A

The consensus seems to be that it runs fine on LAN's, and fine over the internet with 64 bit Vista and Internet Explorer, but bogs down over the internet on 32 bit processor and IE environments.
Jul 25 '09 #2

P: 33
Thanks puppydogbuddy. I searched through google and didn't find much. I guess I should have thought about the Microsoft forums.

Appreciate it.
Jul 27 '09 #3

Post your reply

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