On May 28, 4:20 pm, AndyW <AndrewMWal...@totalise.co.uk> 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
> report in Crystal Reports.
>
> 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.