[AccessD] Updating queries with linked tables

Roz Clarke roz.clarke at donnslaw.co.uk
Mon Mar 31 09:32:57 CST 2003


Dear all

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???

TIA

Roz
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030331/ee477b28/attachment.html>


More information about the AccessD mailing list