Hello All,

I recently created an aggregate view in SQL Server which returned around
2000 records in 4 columns. In Access I created a linked table which
linked to the view and made a combination of all 4 columns the unique
record identifier. Fine.

I then changed the value of columnC in the view so that it was obtained
via a subquery. However, this made Access run like a DOG (a slow,
arthritic one) and some of the lines just said #Deleted instead of the
values I could see when I opened view in SQL Server.

I tried recreating the linked table but this had no effect. Taking out
the subquery made the table open ok again.

The view runs instantaneously in SQL Server (with the subquery), so my
question is this:

Where does the processing of the view take place - on the server or the
client pc?

Also, why do some of the rows show as #Deleted when they are unique and
clearly there in SQL Server?

Yours confusedly,

Carol.


This email and any files transmitted within it are private and confidential.
If you are not the intended recipient, this email and any attachments within it have been transmitted to you in error.
You are prohibited from using, copying, distributing or otherwise using the information contained within this email.
Nothing in this email message amounts to a contractual or legal commitment on the part of Optilan unless confirmed by a communication signed on behalf of the company.
Any email cannot be guaranteed to be secure, error free or free from viruses. Although every possible care is taken by Optilan, Optilan does not accept any liability whatsoever for any loss or damage which may be caused as a result of the transmission of this message by email.


MS Sql Server LazyDBA home page