Re: MailMerge hangs and crashes with Access on Server ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query?..."Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ... (microsoft.public.word.mailmerge.fields)
Re: Performance Benchmarks? ... Are attribute relationships defined properly on the dimensions?... If you run Profiler against the server, how long is spent in "Query... I have created aggregations (Partitions tab in cube design).... (microsoft.public.sqlserver.olap)
Re: Performance Benchmarks? ... adding memory on the server can help you; more data can be cached on the ... Here is my test query.... )} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_UNIQUE_NAME ON ROWS FROM ... I have created aggregations (Partitions tab in cube design).... (microsoft.public.sqlserver.olap)
Re: MailMerge hangs and crashes with Access on Server ... restructuring a complex query.... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ... (microsoft.public.word.mailmerge.fields)
