William Hindman
wdhindman at bellsouth.net
Tue Apr 1 20:54:11 CST 2003
Message...to heck with queries Roz ...tell us about the wedding, the honeymoon ...and where the pics are? :))))
William Hindman
"War is an ugly thing but not the ugliest of things; the decayed and degraded state of moral and patriotic feelings which thinks that nothing is worth war is much worse. A man who has nothing for which he is willing to fight, nothing which is more important than his own personal safety, is a miserable creature and has no chance of being free unless made and kept so by the exertions of better men than himself." John Stuart Mill
----- Original Message -----
From: Roz Clarke
To: 'accessd at databaseadvisors.com'
Sent: Tuesday, April 01, 2003 10:52 AM
Subject: RE: [AccessD] Updating queries with linked tables
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
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
------------------------------------------------------------------------------
_______________________________________________
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/524ed3ce/attachment-0001.html>