Link SQL Server view into Access

Posted on 2004-11-16
Last Modified: 2012-06-27
SQL Server 2000, Access 2000

I have a SQL Server view that I linked into Access as a table. The view times out when either opened or used as the source of a report. I know I can create a query off of that view and set the timeout property in the query but I do not want to do that. Is there any way to set the timeout just for the table?

Question by:teneighty
    LVL 8

    Accepted Solution

    Seems like you may want to have a look on sql as to why it takes so long (paste the view source into query analyser, turn on display execution plan run the query and then see what costs so much, maybe run the index wizard over it and see if that fixes it)

    I don't know of a way to change timeout for just one but if everything else is working it shouldn't really matter should it? Just set it really high.
    LVL 12

    Assisted Solution

    I'm guessing, because I can't find solid documentation, that this particular timeout is set in the ODBC driver configuration.

    The only way to change that, I think, is to edit the registry.  

    I would strongly advise against it, in fact I'm unwilling to test it.

    But if my hunch is correct, the relevant registry keys seems to be located at

    Again, I think it would be *highly* inadvisable to change this unless you're absolutely certain you know what you're doing.  Messing around in the registry can render your computer UNBOOTABLE AND INOPERABLE.

    Don't you think just running a query would be better?  It's certainly MUCH lower risk.


    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
    Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now