How do I prevent "Timeout Expired"

  • Thread starter Thread starter Conan Kelly
  • Start date Start date
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
 
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
 
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
 
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
 
Back
Top