what are requirements for updateable query?

[Guest]

What are the requirements for making an updateable query?

If I am joining two tables in a query, it will probably never be updateable,
right? Are there any good workarounds?

What I would like to do is: Beginning with two tables, one has userID and
alternate email addresses. The second table has userID and lots of other
information.

I want to create a query that grabs the records for the userIDs that do
contain alternate email addresses, and swap out the current email with the
alternate. Then, in a form I run some other calculations and add some
additional information. Problem is, because my current query is not
updateable, I can do everything I want except update the form at the end of
my process.

 

[Guest]

You can set your form's RecordsetType = 1 (Dynaset (Inconsistent Updates)).
But there might be some problems, ie. I think I would create a form with a
subform with different recordsets.

Vlado

 

[dbahooker]

learn how to write joins, subqueries, derived queries; etc

MDB is for lamers and retards
SQL Server supports 'temporary tables' and a whole bunch of other
concepts that MAKE YOUR JOB EASIER

 

[Allen Browne]

See:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html

 

[Guest]

Thank you much, I'll check it out.

See:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html