I think you should try to "flatten" a bit the query on BigTable

Then only, I'd bother going onto the details of working out each sum.

The advantage would be that you...

Yes, I think it would affect us and, as per the article, we could clear the cache if needs be.

Thanks for the link

Actually, if you think the approach is not "correct", I am interested to hear about it.

Regarding the Dimension Security, it was not my choice and I tried to dissuade against...

Nice!

Yes, I like the idea. It would do exactly what I need I think.

Thanks

I have since discovered more...

I have the laptop with me and could do a few experiments.

The problem is "timeout" after about 35 seconds.

I tried without success changing the "General...

Brilliant!

Many thanks

Damn!

Ok, I'll try to come up with a simple piece of code based on one of the sql server sample databases...

Can't do it right now but I'll be back!

I just tried that.

In that case, it first blows up when doing the refresh because ADO tries to investigate the stored proc by firing it with no parameter and the...

It's a little bit longish but here we go.

My ADO reference is ADO 2.5 (I don't know whether I can use 2.6 yet)

Function TrackApplicationUsage()

Dim cmd As...

True.

A bit messy but it could help in some cases...

I'll try to find out if my customers have ADO 2.6 on their workstations...

This is what I first tried because I know this as "good practice" but ADO does not care and send the stored proc request without the parameter names... which fails...

I like that!

I don't have control of the runtime environments...

How can I check whether my potential users have ADO 2.6?

Can I check this through trying to create some particular object...

That's interesting because I kind of removed the primary key from one of the tables to make sure it could not do an update on it without my triggers!

I did...

Actually, I have been testing using a simple view with two tables. No form involved.

I create an INSTEAD OF INSERT and INSTEAD OF UPDATE triggers, yet MS Access still views...

If I declare my command as type adCmdStoredProc, then the problem is that ADO fires the parameters without name in the order they are declared.

This is manageable but very poor...