Hi
I am not experienced in database technologies, so please help me.
I have an access table that is just a copy of the sql table resided on the SQL Server.
Once in a while, I would have to update that Access with changes made to SQL table.
What should I do?
Is it better to copy the whole SQL talbe again, or...
How would I spot the changes in the SQL table?
Please advise me on this.
Thanks
I am not experienced in database technologies, so please help me.
I have an access table that is just a copy of the sql table resided on the SQL Server.
Once in a while, I would have to update that Access with changes made to SQL table.
What should I do?
Is it better to copy the whole SQL talbe again, or...
How would I spot the changes in the SQL table?
Please advise me on this.
Thanks