Roz Clarke
roz.clarke at donnslaw.co.uk
Tue Apr 1 09:52:58 CST 2003
No blank record, all fields locked. It wouldn't surprise me if this is just a 'feature'. R. -----Original Message----- From: Susan Harkins [mailto:harkins at iglou.com] Sent: 01 April 2003 16:25 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Updating queries with linked tables Well, when you say "combine" -- I think of append or UNION. Relationships "join" records -- nothing wrong with the way you siad it -- I just thought I'd check to make sure. So here's the next question -- how do you know it's not updateable? Are you getting an error message? Is there a blank (new) record at the bottom of the query in Datasheet View? Susan H. 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 <mailto: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. _____ _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030401/e2103de2/attachment-0001.html>