[AccessD] Perhaps I'm just being a dolt...I hope!

[Charlotte Foust]

What version of access was it built in and what version is it running in?
Some versions back the query engine would let you edit values in multiple
tables in a query as long as all the primary keys were included in the
query design.  The query engine has become much more strict about
multi-task queries and usually will allow you to edit only the outer joined
tables.  Apparently asynchronous updates were the default type of dynaset
back in the day but that is no longer the case.

On Nov 10, 2016 12:35 PM, "John W. Clark" <John.Clark at niagaracounty.com>
wrote:

> I'm praying that this is something simple that I am missing. I'm
> completely OK with anyone saying, "John,  you are being dumb, here is your
> simple solution..." As illustrated by my general absence, and my rare
> visits to this list...just can't quit it though...I don't do much with
> Access these days.
>
>
> But...
>
>
> I have this database downstairs in our treasurers department that has been
> running smoothly and relatively trouble-free for years. They called me with
> some weird issues a couple of weeks ago and I ran a "repair and compact"
> because that is what I do when weird problems arise...again very rare. It
> did take care of the weirdest of issues, as I figured it might...it was
> saying a record was already entered that just simply didn't exist. However
> another issue remains...this is actually not my cause for the help request.
>
>
> My problem is...and this seems to have begun around the same time...SEEMS
> to have...is that where they were once able to enter a value into their
> queries, they are no longer able to do this. The one that brought it to
> light is a date field, which pops up a calendar as it should, but clicking
> doesn't enter a value, nor can you do it manually. I started looking at
> other fields and other queries and it is all of them.
>
>
> Also, there are three people that use this database, thus three front-ends
> among the individual PCs, and I have a copy on mine as well. I checked
> another, hoping I just needed to copy a new front-end to the offending PC,
> but it was both (never checked the 3rd...figured it was the same). Then I
> came up to my computer and tried it with the same results.
>
>
> I thought it was perhaps something to do with filtering which they're
> using, but no it is all queries. Then I thought perhaps a rights issue with
> the back-end data, but they are able to enter into forms and tables...I
> need to double-check the tables statement.
>
>
> No nums-lock, no scroll-lock, I don't know  what could cause this...I'm
> out of ideas. And, I am out of time, we're in the midst of a GroupWise to
> Exchange migration and I'm swamped as it is. Aahhhh! Please help an
> unfortunate soul!
>
> Notice: This electronic transmission is intended for the sole use of the
> individual or entity to which it is addressed and may contain confidential,
> privileged or otherwise legally protected information. If you are not the
> intended recipient, or if you believe you are not the intended recipient,
> you are hereby notified that any use, disclosure, copying, distribution, or
> the taking of any action in reliance on the contents of this information,
> is strictly prohibited. Niagara County is not responsible for the content
> of any external hyperlink referenced in this email or any email. IF YOU
> HAVE RECEIVED THIS TRANSMISSION IN ERROR, PLEASE NOTIFY THE SENDER
> IMMEDIATELY BY EMAIL AND DELETE THE ORIGINAL MESSAGE ALONG WITH ANY PAPER
> OR ELECTRONIC COPIES. Thank you for your cooperation.
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>