Data Warehouse

[Guest]

Anyone know any good references or setup techniques for starting a data
warehouse using Access exclusively? I need to take data from many different
tables and queries and store that info in a separate db or tables, then be
able to write queries and reports that users can select to build their own
editable custom reports. I see on the web where many places use SQL servers
to pull all info generated and write queries from that, but I think it may be
manageable for our organization in access.

 

[Jeff Boyce]

What is it about your situation that you feel doesn't warrant using
SQL-Server? Please note, I am not promoting SQL-Server, just asking for
more information about the requirements/constraints you are considering.

If you want folks here in the newsgroup to make more specific, informed
recommendations, provide a bit more specific background.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Maybe it's time I start using SQL-server...I have about 10 different agencies
using a variety of access dbs and excel ss for their data...I'm guessing I'll
need to store their info from about 50-75 different tables and try to write
different parameter queries so that users can pick the query that they need
to give them a custom built report. I feel somewhat comfortable using access
with vb and have heard of possible vb code problems using sql with an access
front end...not to mention learning how to build sql tables and try to link
them to current access dbs or queries. I'm going to try to upsize most of my
access to sql later this year anyway, so maybe I should bite the bullet and
do it. I would like to see some examples of a small company that's done this
sort of warehouse concept. I'll have to hit the library. Thnks