My business requirement is to copy the data from SQL to access tables and then use it to display the data on the forms.
I cant link it to the table manager option as its disabled.
And I have to do it everytime the form is opened.
Since there is no LAST_UPDTAED_BY column in the SQL table, I always have to delete the access table and reload all the data again as there is no way I know which records are updated for either incremental refresh or Update query
Is the do while option the only option availble?
Do While r.EOF = False
r1.AddNew
r1.Update
r.MoveNext
Loop