[AccessD] Updating queries with linked tables

Have you considered a form with a Tab control on it? Each page of the tab
control can then have it's own sub-form, one linked to the SQL data and one
to the local data.

Lambert

> -----Original Message-----
> From:	Roz Clarke [SMTP:roz.clarke at donnslaw.co.uk]
> Sent:	Monday, March 31, 2003 10:33 AM
> To:	'accessd at databaseadvisors.com'
> Subject:	[AccessD] Updating queries with linked tables
> 
> 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 
>  << File: ATT6481684.txt >>