Hi!
I have an Access DB with linked sharepoint lists. DB runs well, lists are not very big, not a lot of columns... Some days, and some times through out the day, on opening a table for the 1st time after opening the database, it takes a long time to open. But, the 2nd opening is quick.
On start of the Access DB, with VB, I query an 'Admin' linked table (sharepoint List) with users and compare them to Environ("USERNAME") - this will define the user as an admin or not if they are on the 'list'. This table (right now is 4 lines long and has 4 columns. Some days it only take a couple seconds... Some days it takes 20 sec!
Seems to me that upon opening the database and making that first request to a sharepoint list - it takes a long time. But the subsequent pings to the table are quick. Sorta like the 1st time opening a table the system needs to find it, but the 2nd time it remembers where it is>>
Any ideas? Is it a caching thing? Can't be. The table described above only has 4x4 = 16 elements. Some days, it does run very quickly from opening.
I work for a global top 100 electronics company.
Thanks.
Steve
Harrisburg, PA USA