Hey Everyone,

Perhaps I am not asking the right question, but I cannot find anything to get me pointed in the right direction. I have a db where a few of my tables are linked to a SharePoint site. As you all may know, the first time you acess the tables after the link, the system will cache to increase performance and load the tables onto the local machine.

What I would like to do is the first time the user opens the db (initial roll out, or an updated fe is rolled out), I would like for the system to cache the tables and then shut down the db and reopen it. I figure I can have a local table that can count how many times the db is open. On initial rollout or updates, the table would be set to 0. If 0 then the system would run the command to cache the db, close and reopen to the main page. It would then update the table count to 1 and would not run again. I could even delete the table after the initial run.

The issue is trying to find a vba that would actually cache or sync or something along those lines. Or maybe another way to do this.

Anyone have any thoughts?

Why would you want to do this shut down and reopen step? The fact that there isn't a readily available way to accomplish it should suggest that it's probably not a big concern. Are you concerned that the caching will slow things down later? I think that is a baseless concern actually. But perhaps you have another reason to want to do this?

Hey Grover,

Your right. Since this post, I have actually taken the approach to display a message while the system runs the cache on the first login attempt. The approach is not to actually close down any longer. What I decided to do was count in a local table the number of logins. If the counter was zero the db will display a Msgbox indicating that the system will "Initialize". At which time I run a loop until the end of record on all linked tables which forces the initial cache.

When done, displays a MsgBox thank you message and then takes the user to the switchboard. Since the counter has updated to 1 from that point it never runs again. It appears to be working pretty well other than trying to figure out how to get a status bar to run properly as it loops through the recordset. But I am playing around with the code and should hopefully find the right combo.

Thanks for the response.