SQL to Access table

[usertest]

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

[June7]

Already asked with https://www.accessforums.net/showthread.php?t=88784