SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Linking Access to SQL Server Reposted on SSC

This is an older article that was recycled for Fri, but still seems to get a decent number of views and some good discussion. It's fun to see who sees the power of Access and not just the pain! I still use Access for some really adhoc reporting and for one off data changes, just faster than SSMS in most cases. Not because the tool is faster, it just has a better UI.

The article is at http://www.sqlservercentral.com/articles/Access/linkingaccesstosqlserver/2176/.


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.


Posted by Kathi Kellenberger on 5 November 2007
I've done quite a bit of Access consulting over the years for tiny businesses, sometimes run out of a basement or garage. These companies generally don't have an IS person. I would much rather teach them how to do the compact and repair and then backup an Access file that expect them to deal with SQL Server. I think Access definately has its place and it is a matter of using the correct tool for the job.
Leave a Comment

Please register or log in to leave a comment.