R
Roy Goldhammer
Hello there
I need to build a complex query which have relationships from 4 tables. and
this query must be updatable.
Because the data on the tables is very big: (1,500,000) from table1,
(500,000) from table2 ect...
because my database is sql server I decided to build the query as view on
sql server and link it from access as table so it can be use for insert and
update.
The problem occure when i set it on access it asked me which of the fields
is primary key and didn't allow me after that to update it.
is there a way to use sql server views in access for insert and update data?
I need to build a complex query which have relationships from 4 tables. and
this query must be updatable.
Because the data on the tables is very big: (1,500,000) from table1,
(500,000) from table2 ect...
because my database is sql server I decided to build the query as view on
sql server and link it from access as table so it can be use for insert and
update.
The problem occure when i set it on access it asked me which of the fields
is primary key and didn't allow me after that to update it.
is there a way to use sql server views in access for insert and update data?