Are materialized views supported in MS Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
Hi Yannick,

I'm guessing here, but

Materialised views -> Temporary tables? Disconnected recordsets?
Virtual views -> queries? recordsets?
 
Materialised Views - Yes! Forms! Reports!

Virtual Views - What are these then?
 
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.
 
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


Lynn Trapp said:
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


John Nurick said:
Hi Yannick,

I'm guessing here, but

Materialised views -> Temporary tables? Disconnected recordsets?
Virtual views -> queries? recordsets?
Click to expand...
of
a
Click to expand...
Access,
Click to expand...
 
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.
 
Back
Top