I have been using Access for quite a while as a client server type program. I have developed stand alone databases that sat on a servers where each client accessed the databases from their desktops.
The new situation requires that I access a datawarehouse that sits at a remote location and query the data, creating new tables, queries and reports from within Access for statisical analysis.

My question is:
1.) Does access have this ability
2.) If yes, how do you perform this.
3.) Is this going to be a situation where I will be writing a ton of SQL statements

Thanks,

Chris

1. Yes, Access can connect to many/most different datasources (SQL Server, FoxPro, MySQL, etc.)
2. The best method of connection is sometimes dependant on the source. (ex. I prefer an Access ADP when connecting to SQL Server. But ADP's ONLY work with SQL Server and no other sources)
3. I have found that the most robust/flexible way of controlling an app is to write custom SQL in code. However, you can still use the QBE grid to build queries, if you like.

Is it possible to connect to the datawarehouse using ODBC?

Yes, ODBC is a method of connection, also.

I guess with that being said I would have to determine what method or program is warehousing the data to make sure I can find drivers unless Microsoft has them.

Thanks again

No problem.