Thanks for the great post, Louis!

Thanks, Andy!

This is a topic that has come to the forefront for me lately, specifically, we have an operational database, and we want to get to the point of being...

Metra,  Thanks for your response!  However, System Objects and Hidden Objects are already unchecked under Tools/Options in Access.

dan

No.  Users will be connecting with their AD logins (windows authentication/trusted connection).

dan

Thanks for your response!

However, what I'm really looking for is a way to get the system views & tables to not show up in the Link Tables box in Access. ...

Thanks both for your responses!

Charles, you have a valid point and some good suggestions, however, I do have some reasons (I don't know if they're *good* or not

Greg,

I agree, it would be nice to be able to use something like DTS for the ETL.

From my experience trying to extract data from Unidata, though, I have not been...

Greg,

We also are looking to create a data warehouse, on a budget, against a Unidata database.  We also are looking at building the data warehouse in MS SQL Server.

One of...

Although I also am motivated by most of the things people have mentioned already, especially the desire to make useful things for people and improve tools, to help people do...

Yeah, I really appreciate the QOD, too.  It's probably the only feature of the newsletter that I could truthfully say I read in detail in every newsletter.  That's because it...

I found and opened the server network utility, and all protocols were disabled. I enabled TCP/IP, stopped and restarted the SQL server service, and now the server is listening...

For our web product, our company chose Active Reports by Data Dynamics as an alternative to Crystal Reports.

Very good article. I actually have been using Access to back up SQL tables, and it has saved me A LOT of time. Andy's suggestion is very relevant...