Creating Views in Access?

[daph]

Hi everyone,

Is it possible to create something similar to Views (like in Oracle) in an access database?

I'd like to have a dynamic table that would update automatically, when the tables associated with it are updated.

I'm open to suggestions.

Thanks a lot!
Daph

 

[cmmrfrds]

No, you need to manage it yourself in Access.

 

[JeremyNYC]

Daph,

Are queries not what you need? I've not used Oracle, but my understanding was that what y'all call "views" we call "queries".

When you speak of updates, do you mean to the data or to the structure of the tables?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.