My application accesses a server database and downloads some tables to a client database. To do this I am looping round all the tables on the server I require and then running an INSERT INTO query using an ADO connection, on each table.
I am executing the query string on the ADO connection like this ...
However when I goto access the information on the client database it isn't there and I have to wait for a few seconds for the tables to copy.
Is there anything I can do within the code that will only display my application one the information has downloaded. I can't check the record count of the client tables as there may be no information to download. I simply want the query to execute on the connection finish and then display my application.
I am executing the query string on the ADO connection like this ...
Code:
myConnection.Execute strSQL
However when I goto access the information on the client database it isn't there and I have to wait for a few seconds for the tables to copy.
Is there anything I can do within the code that will only display my application one the information has downloaded. I can't check the record count of the client tables as there may be no information to download. I simply want the query to execute on the connection finish and then display my application.