http://www.microsoft.com/downloads/details.aspx?FamilyId=BEB5D477-2100-4586-A13C-50E56F101720&displaylang=en

Keith Henry

DBA/Developer/BI Manager

Clustered indexes change the way all the other indexes on a table work, so this would be a lot dependant on what other indexes are there. It...

"TAB:" means this is waiting for a table, "29:" refers to Database id 29 in master..sysdatabases.dbid, ":1:" refers to file 1 in sysfiles and ":326542" refers to the...

quote:

---

I don't do any Access development, but we do use it (at work, not here) for data management and the linked tables...

What version of OWC can you use? OWC XP can return results from MDX statements but earlier versions can't

Keith Henry

DBA/Developer/BI Manager

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=17530&FORUM_ID=61&CAT_ID=5&Topic_Title=Question+of+the+day+2+cent&Forum_Title=Anything+that+is+NOT+about+SQL%21

JordanAC pointed out the same thing. I need to stay up to date more

Keith Henry

DBA/Developer/BI Manager

From that description stick with access for the backend. jet to jet is marginly better than jet to sql, but still awful

Given how amazingly easy...

A problem with SQL servers is that they can't share load unless it is done programatically at the application level. I find unioned views across linked servers...

quote:

---

Didn't you make the update to BOL SP3 ???

---

Yeah, but I only read...

Don't use linked tables for this, as they are generally even worse than looping through the recordset. In Microsoft Access 2000 and above you can create projects...

You can specify multiple cubes in an MDX statment

Keith Henry

DBA/Developer/BI Manager

quote:

---

Sounds like an end user response not a programmer. =)

---

In that case it...

Sounds like some kind of ASP session timeout

Keith Henry

DBA/Developer/BI Manager

Cool! I love the way MS adds new features with barely any documentation. You should add it as an FAQ

Keith Henry

DBA/Developer/BI Manager