Displaying pass through query

[JimP]

I have an append query that uses a pass through query (to a SQL Server db).

When the db that is referenced is small, the query opens up in design view
quickly.

However, when the db is large. the pass through query can take many minutes
to open.

Is there a way to open up the append query in design view, without waiting?

 

[PieterLinden via AccessMonster.com]

I have an append query that uses a pass through query (to a SQL Server db).

When the db that is referenced is small, the query opens up in design view
quickly.

However, when the db is large. the pass through query can take many minutes
to open.

Is there a way to open up the append query in design view, without waiting?

There are lots of ways to slow down queries when going between Access and SQL
Server. If you are appending from one Db to another, make sure you have
proper indexing on your tables (basically, they match). I upsized a 5000 row
table from Access to SQL Server and proper indexing made an enormous
difference. So I would start there.