Sub Query produces an editble recordsource? (1 Viewer)

[evanscamman]

I thought that if you use a subquery you can't have an updatable query.
This has always been true for me.

But now I have a query that includes a subquery among its source tables and it is fully editable. Now I'm wondering if this is just a fluke, or if there is some logic behind it?

Thanks,
Evan

 

[dkinley]

I've never tried - suppose it's hypothetically possible if linked correctly? Check this link, it only makes a case for when they are not linked.

http://msdn.microsoft.com/en-us/library/aa198446(office.10).aspx

-dK

 

[RainLover]

What you have is the standard.

Queries that are not editable are things like when you use Totals.

EDIT

That is a very godd link that dkinley posted.