MS Access ODBC Connetion Timeout Error

There are some of us unfortunate DBAs out there that are forced to support MS Access connections to our database. I am one of those poor souls.

I manage a Microsoft Dynamics NAV database with over 26,000 tables. When one of our users was trying to create a linked table in Access 2007 he was presented with a ODBC–call failed Timeout expired (#0) error.

Name That Caption Contest

Share
Thomas LaRock (Blog | Twitter) author of DBA Survivor: How to Become a Rockstar DBA is offering the opportunity to win a copy of his book. The contest is to create a caption for the banner on his website, also found below.

Here is my Caption
“If a backup fails and no one gets an alert, [...]

MS Project Server and Backup Best Practices

Share
Microsoft’s Project is a very standard project management tool that most Project Managers are all to familiar with. While Project is a great application it was limited to local information. Microsoft’s Project Server extends Project’s capabilities and allows the sharing of resources and information across an Enterprise.
Project Server 2007 is built around the SharePoint platform [...]

Site picked up for Syndication

Share
I am pleased to announce that jonathanagardner.com has been picked up for syndication on SQLServerPedia.com.  A special thanks to Brent Ozar Blog|Twitter for helping me make this happen.  Our first posts can be found here…

Using Joins instead of Sub Queries: a Case Study

During a recent upgrade from SQL 2000 to SQL 2005 some poorly written code was exposed on a custom web application. Users and developers started reporting that their applications were timing out. One of the queries I posted in the Execution Plan Challenge. Another exposed query involved a sub query.