I'm creating a database with a backend in SQL server and a front end in access. I also use temp tables stored in each access client to base any reports on(for flexibility). Within the visual basic code I connect to the tables using ADO with no problems.
strPathToMDB = "c:\access applications\Price support system.mdb"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathToMDB & ";"
Set connec= New ADODB.Connection
connec.Open strConn
However when I populate the temp table, then open the report that is based on it the report opens and displays before the table has been fully populated. The SQL insert commands are performed asyncronusly which does not solve the problem.
My best solution so far is to make the application wait 10s before opening the report, however this is both inefficient and there is no guarantee that the whole temp table will be included in the report.
If anyone knows how to make the report wait unitl the updates of the temp table are completed or an alternative way to connect to the local tables it would be appreciated
strPathToMDB = "c:\access applications\Price support system.mdb"
strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & strPathToMDB & ";"
Set connec= New ADODB.Connection
connec.Open strConn
However when I populate the temp table, then open the report that is based on it the report opens and displays before the table has been fully populated. The SQL insert commands are performed asyncronusly which does not solve the problem.
My best solution so far is to make the application wait 10s before opening the report, however this is both inefficient and there is no guarantee that the whole temp table will be included in the report.
If anyone knows how to make the report wait unitl the updates of the temp table are completed or an alternative way to connect to the local tables it would be appreciated
