Re: Non-updateable query issue

Steve, either I have not understood you, or this is an exercise in frustration.

You cannot prevent multi-user issues by giving separate copies of the data. How will you ever sort them out?

Say Fred deletes record 79 from Table1, and then Betty changes the phone number for record 79 in Table2 afterwards. You now have a deletion (which you have presumably cached somewhere), with a more recent edit. Do you resolve that by deleting the record in Table2? Or by restoring the record in Table1 because there is a more recent edit? Or ...?

It seems to me that you are creating more problems than you could possibly solve.

Anyway, here's a list of things that can cause a query to be read-only:
http://allenbrowne.com/ser-61.html
The most likely cause in your case is JOINs where neither end has a unique index.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sjwopg" <sjwopg@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:705B9AD0-41AE-41B3-AD82-71A3BEFF20D1@xxxxxxxxxxxxxxxx
I am creating an application which will have 20+ users. In order to minimize
errors or record locking issues, I have created three tables for each record.
The users will enter/edit their fields without another user being in the same
record.

Table1 has a primary key. Tables 2 & 3 have primary keys, and a foreign key
that relates to table1.

I created a query joining Table1 to Table2 using the T1 primary to the T2
foreign, and joining Table1 to Tabel2 using the T1 primary to the T2 foreign.

This makes the query unupdateable. If I join T1 to T2, or T1 to T3, each
table is updateable. It is when I join the three tables as described above,
that the tables become unupdateable. I've tried a number of different
scenarios, but it seems that whenever I try to join Table1 to the other two
via the Table1 primary key, the query is unupdateable.

Any suggestions?

Thanks in advance,

Steve

.

Relevant Pages

  • Re: Amount of time between records
    ... FROM table1 LEFT JOIN table2 ON condition ... Since the 'condition' is not a simple equality, you cannot edit the query, ...
    (microsoft.public.access.queries)
  • Re: double data entry with msgbox function?
    ... loop through the fields in Table2 comparing each field to its corresponding ... Table1.Do you Wish To Edit One Of The Tables?",vbYesNo,"Field Values Don't ... <Code To Edit Table1> ... Need a month calendar or 7 day calendar? ...
    (comp.databases.ms-access)
  • Re: Non-updateable query issue
    ... joined to the master, showing all the records, the query is not updateable. ... Say Fred deletes record 79 from Table1, and then Betty changes the phone ... with a more recent edit. ... via the Table1 primary key, ...
    (microsoft.public.access.queries)
  • Re: DBLookupComboBox question
    ... > For the sake of example, the table I'm reading from is table1, and the ... > DataField -> recordID ... the edit part doesn't display anything. ... > active, and table2 is in edit ...
    (comp.lang.pascal.delphi.misc)
  • Cannot Add Data
    ... Hi, I have table1 and table2, both are linked, and a query has been ... cannot edit any records nor can I move to a new record on the forms. ...
    (comp.databases.ms-access)
Loading