Re: Since my tables grow - Access hangs on linked tables - workaround found

[Peter Steinbach]

I figured out that when I run the same statement with a where caluse, it works.

Example for the record source of a form:
"select * from table" crashes

"select * from table where id >-1" is o.k. although it returns the same recordset as all ids are greater than 0.

At least for our application this workaround works fine. I will keep you updates if I run into new problems.
Best regards