Re: Can't Update Records

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 06/23/04 

Date: Wed, 23 Jun 2004 17:29:29 -0600

On Wed, 23 Jun 2004 16:42:49 GMT, "SeniorTrans"
<SeniorTrans@earthlink.net> wrote:

>Hi,
>
>I've now put both tables in the same database

You're apparently assuming either that you are the only person asking
questions here, or that all the volunteers have perfect memories and
remember your post from however long ago. Neither assumption is valid!
Which "two tables"?

>...not linked... I have joined
>the two tables with a one-to-one join.

One to one relationships are VERY VERY RARE. If you're not familiar
with the term "subclassing", then you probably don't want a one to one
relationship. One to many is MUCH more likely.

>Have built a form and use that query
>as the underlying Recordsource. But it will not let me update the record.
>when I try to edit...I get a warning that someone else has edited the record
>and saved it before I did and therefore my changes won't be saved...and I'm
>supposed to try again.
>
>What am I doing wrong? I've made hundreds of forms this way with no
>problem.

If you'ld care to post the SQL of the query, with a description of the
tables; and indicate what the Primary Key of each table is, and how
they are related, perhaps someone could help. Generally you might do
better to use a Form for the "master" table with a Subform for the
related table rather than creating a query to update both.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public

Relevant Pages

  • Re: Access 2000 Make Table Query Warning Box -- use currentdb.execute
    ... currentdb.execute "SQL or action queryname" ... When this query is run, and before it asks the user for the input, I get a warning message that says that the query is about to replace the table with new data, and is the user ok with that?, yes or no. ... As the database designer, I know to answer yes, and it goes through the function with no issues. ...
    (microsoft.public.access.queries)
  • Re: Warn me Not
    ... Use Dirto test if the target file exists. ... Kill it before executing your query. ... I am taking a table in one database and, using a make table query, ... Deletions did not seem to eliminate the warning. ...
    (microsoft.public.access.queries)
  • Re: SQL statement in Perl doesnt work
    ... The last answer by Brian McCauley made me look again at the query result from the database. ... By changing the range of records I got the results I expected in the first place, so I apparently misinterpreted the warning. ...
    (comp.lang.perl.misc)
  • Cross-product and join question
    ... I'm designing a query with DBArtisan against a Sybase database. ... I receive the following 'Warning' from DBArtisan: ...
    (comp.databases.sybase)
  • Re: Append query
    ... Yes Both Append queries run just fine if I just run them from main screen or ... I'll take out the warning. ... >> I am trying to run an Append query from VBA code. ... >> this in the same database to run a delete Query using this code and it ...
    (microsoft.public.access.formscoding)
Loading