Mike,

You need to include the OLAP Administrators with full control over the c:\Program Files\Microsoft Analysis Services\Bin directory.

Stop the OLAP service.

Remotely (unless you have access installed locally) run

ie. \\s825338\MsOLAPRepository$\msmdqlog.mdb

If the...

OK. The problem was that the Bin directory did not have the appropriate security set. Bit of an additional funny. I had to stop the service - copy the access...

Yep, Already tried restarting etc. No Joy. No logging. Any other ideas?

SteveH.

Afraid not. That dictates whether a default value is applied or not. ie. Keep Nulls even though a default constraint exists.