[AccessD] Updating queries with linked tables

Hi Roz

If the primary indexes of the two tables are not equal I guess you'll
probably never succeed with one query.

/gustav


> I have a SQL database which stores core information about members of staff
> here - name, department, phone extn. etc.

> I need to publish this information out to several different departments, all
> of whom need to be able to update the data. At the same time, they each have
> local data requirements which have to be updated alongside the core data. I
> was going to put these in Access databases and give each department it's
> own.

> What I'm finding (and I can't believe I never hit this before) is that
> although the SQL tables can be updated through the Access FE, and the local
> tables can be updated, combine them and wallop, not updateable. Even if all
> the key fields are included in the query.

> The amount of info is about 50/50 and it would be highly user-unfriendly to
> split the data onto separate forms. Is unbound the only way forward???