February 22, 2007 at 12:13 pm
All
One of my clients accesses my production database thru a vpn using MS Access for a front end.
When a table has more than 16 columns, the query errors out with a timeout message.
MS Support cannot figure it out.....Anyone out there have any ideas?
Eric
February 25, 2007 at 3:15 pm
If you're looking to try and extend the timeout?
Don't have access here (boo) but can sort of recall something in the generic setup that might do it.
Failing that, write a simple query that has the * as the field (so returns all fields) and no selection criteria. This then allows you to check the properties of the query and change the timout to 0 (zero), essentially turning off the timout on that query.
Never know, that might work, and it'll still give table like access to the table, just without the risk of someone changing the fundemental table design (probably a good idea).
Cheers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply