Are materialized views supported in MS Access?

[Yannick]

Hello folks. I'm relatively new to MS Access and I'm having a Dickens of a
time figuring out whether materialized views are supported in MS Access, or
even virtual views for that matter. I suspect they are, but...

Cheers,

 

[John Nurick]

Hi Yannick,

I'm guessing here, but

Materialised views -> Temporary tables? Disconnected recordsets?
Virtual views -> queries? recordsets?

 

[Craig Alexander Morrison]

Materialised Views - Yes! Forms! Reports!

Virtual Views - What are these then?

 

[Lynn Trapp]

Materialized views are an Oracle construct (although I read about a few
other DBMS trying to create them too) that are mostly used for datawarehouse
applications. They have 2 primary purposes -- (1) prejoining and
preaggregation of data into a kind of "snapshot" and (2) replication. A
temporary table is probably the closest thing that Access could come to
recreating it.

 

[Craig Alexander Morrison]

I had forgotten that Oracle had used the term incorrectly.

The materialisation of a view should take place in the application,
according to the theory.

--
Slainte

Craig Alexander Morrison

Materialized views are an Oracle construct (although I read about a few
other DBMS trying to create them too) that are mostly used for datawarehouse
applications. They have 2 primary purposes -- (1) prejoining and
preaggregation of data into a kind of "snapshot" and (2) replication. A
temporary table is probably the closest thing that Access could come to
recreating it.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

Hi Yannick,

I'm guessing here, but

Materialised views -> Temporary tables? Disconnected recordsets?
Virtual views -> queries? recordsets?

of

a

Access,

 

[Lynn Trapp]

That's true, but Oracle does their own thing. Kind of like Microsoft...LOL

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm

I had forgotten that Oracle had used the term incorrectly.

The materialisation of a view should take place in the application,
according to the theory.

 

[Craig Alexander Morrison]

They all do their own thing.

We just need to choose the one which is the least wrong, DB2 UDB 8.2 is now
probably the least wrong.