Apologies in advance - I do not know much about Access.
I have a SQL Database that must NOT be able to be updated as it is controlled by another system.
I want to be able to access the data from three tables ... preferably via a sql Query or View
In Access I have found out how to create a Table as a copy of my SQL database table (NOT Linked as I have to prevent Updates). However the data in SQL changes daily, and to refresh my Access Tables I have to Delete and recreate them. Is there some way to Replacing the data in my Access Table without Deleting it?
Also, it would be better for me to Query the SQL tables, or connect to a SQL Database View.
Is there a way to create a Read Only Access Table linked to a SQL Table or Query or View?
Thanks for your help