I have an access front end playing host to an SQLServer db. The db uses just one linked table and access runs queries. My queries time out and get call failure, though I know the sqlserver db is available, I do not know what I could possibly do to make this thing work. Can I increaes the timeout time here to something much larger? It seems to take about 30 seconds to give up. Or is the volume of data to big? I tried to write a vb program to break the data down into smaller quiries to generate a temp table to then generate reports, but this just causes access to all together crash. Testing the sql later I found out it was likely because the query was timing out. I could really use some help if anyone has ideas. Thanks.
Start Free Trial
