by "scottauge@[EMAIL PROTECTED]
" <scottauge@[EMAIL PROTECTED]
>
Jul 9, 2007 at 06:49 PM
On May 28, 4:20 pm, AndyW <AndrewMWal...@[EMAIL PROTECTED]
> wrote:
> Hi
>
> I'm a VB programmer struggling to get to grips with Progress V9.
>
> I've got a program that creates a load of Views that are used for
> re****t in Crystal Re****ts.
>
> I keep getting the following error:
>
> "Failure to acquire exclusive schema lock for DDL operation. (7872)"
>
> I've found enough information that tells me this error is down to
> users being in the system.
>
> If possible I'd like to query the DB to find out who's causing the
> locks via my VB application.
>
> Does anyone know if this is possible.
>
> Thanks
>
> Andy
You need to knock all other users off the DB to make a schema change.
You can find a lot more information at
http://progress.atgnow.com/esprogress/Login.jsp
(no login required even though the URL reads like it).
Looks like you may need to call Progress on this one.
