Linked Table to Sharepoint List - SLOW

[servantofone]

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

[puppydogbuddy]

This has been frequently discussed in the public forums. See this link:

http://sharepoint.microsoft.com/blogs/GetThePoint/Lists/Posts/Post.aspx?List=8d9e2a99%2Df288%2D47c2%2D916b%2D2f32864f7b82&ID=68&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.

[servantofone]

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

Appreciate it.