How do I prevent "Timeout Expired"

[Conan Kelly]

Hello all,

I have a linked table to a large table in a SQL Server DB. I'm trying to do
a crosstab query on this table and I keep getting a "Timeout Expired"
message
(http://home.att.net/~ctbarbarin2/Files/MSAccess_TimeoutExpired.JPG).

How do I prevent the timeout from expiring so I can run my query.

Thanks for any help anyone can provide,

Conan Kelly

 

[Maurice]

Hi Conan,

Seems like the default setting for the timeout is not long enough for the
action. Don't know which version you are using but look under Tools-options
and search for the tab which displays the option with the time-out setting.
Try extending that time to what you think is appropriate. (in Acc 2007 under
Office button - Options - Advanced)

Maurice

 

[Aaron Kempf]

I'd just reccomend using Access Data Projects
they run so much faster you can probably jsut get your query done without
increasing any timeouts

 

[Tom Ellison]

Dear Conan:

Is the query stored as a SQL Server View? You can link to this as a table
in an MDB. Is it "pass thru"?

How long is the timeout? You can set this parameter if desired.

However, if it is timing out, then optimization or careful recoding may be
the best solution.

Tom Ellison
Microsoft Access MVP

 

[Aaron Kempf]

CORRECTION

Sql Passthrough is depecreated; linking to views is unreliable and causes
locking probelsm on THE DATABASE SERVER

how dare you, kid

move to ADP or use an unreliable, unmanageable data mess