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>