How do I prevent "Timeout Expired"

M

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
 
A

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
 
T

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
 
A

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
 
Top