[AccessD] Updating queries with linked tables

Roz Clarke roz.clarke at donnslaw.co.uk
Tue Apr 1 03:07:33 CST 2003


Standard left outer join on staff ID - is there another way?! 
*bangs head on desk*
 
R.
 
 -----Original Message-----
From: Susan Harkins [mailto:harkins at iglou.com] 
Sent: 31-Mar-2003 17:20
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Updating queries with linked tables



How are you combining your tables? 
 
Susan H. 
 
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.

 

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


More information about the AccessD mailing list