Jul 26 2006, 07:42 AM
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
Jul 26 2006, 07:56 AM
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.
Jul 26 2006, 08:48 AM
Is it possible to connect to the datawarehouse using ODBC?
Jul 26 2006, 08:50 AM
Yes, ODBC is a method of connection, also.
Jul 26 2006, 09:00 AM
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.
Jul 26 2006, 10:05 AM
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here