Unanswered: Anyway to make a timer/delay VBA module?
It's a little complicated, but I'll try to keep it as simple as possible. I have 6 tables linked to my central database. The code/macro in the central database opens the other 6 databases to copy down the tables locally again with new data. Problem is the one table takes a very long time to download, and the macro in the central database keeps moving on in it's process. In fact, it moves onto the point where it needs to utillize the table that's still being downloading, and thus cannot run the query on it because it's in use (I get an exclusive user mode error because of it). Is there anyway I can do a delay on this thing before it moves on down to the next command in the macro? All I need is for it to kind of hold off on progressing for about 7 minutes and then continue on.